Search results for query: *

hey PH Thanks again ... i'm learning quite a bit here. Your suggestion helps things a bit as at least the following combo box (ComboBox2) is not highlighted. It seems very difficult to highlight the contents of ComboBox1 or even setfocus there. What is also interesting is that after the 'exit...

If i choose a "focusable" control like a textbox i get the error: Runtime error '-2147418113 (8000ffff)': Unexpected call to method or property access.

Thanks for reply PH ... Unfortunately i get the error: "Run Time Error '2110': Can't move focus to the control because it is invisible, not enabled or of a type that does not accept the focus." due to the line: Userform.ComboBox2.SetFocus

Hi Everyone I am using Excel from the Microsoft Office (2003) package. I have created a userform with combo boxes allowing the user to make certain selections. Lets say that ComboBox1 has the added items: "0", "1", "2" when the userform is initialized. I require the user to select one of...

Thanks Geoff! It works

Hi everyone I am using Microsoft Office (2003) and i've created a userform that allows the user to input values into text boxes which are later populated onto a spreadsheet. My problem is that i am struggling to clear all the textboxes afterwards (there are many of them). I've tried this...

I am using VBA (microsoft excel).

Hi there An abbreviated version of my problem is that i have a set of 4 numbers for example (1, 2, 3 and 4) and i would like to be able to have an object which holds these 4 numbers where any one of them can be randomly chosen. If, lets say, 2 is randomly chosen, then i would like that the...

Hi there I have a form which updates a mini database in excel (2003). Once details have been submitted by the form to the workbook, it would be good to have the option to reset the form i.e. reload the form with original blank text boxes, populated list boxes etc. My question: is there a...

Thanks guys ... that helps! :-)

Hi Im in the process of designing a form in excel which captures certain fields and then inputs the data into the relevant places on a spreadsheet running in the background. My problem is that when i check for errors, e.g. a blank field ... ***** Select Case busname Case ""...

Thanks Skip Working now

thanks doesnt work though

hi there Im trying to update charts in excel using named ranges. To simplify lets say that the x-axis comprises 12 months (jan -> dec) and the y-axis has 2 sets of data, a 'target' series and an 'actual' series. Lets say that the values for my 'target' data series are found at...

Hi there I dont think this should be too difficult ... In Excel, how does one return the row number of the current active cell in the worksheet? Thanks

Thanks Matt, that helps a lot ... Is it possible to, for example, reference a textbox on page1, from a command button on page 2 (command button which executes a function which needs values from page 1) without using a textbox on page 2 that is linked to the textbox on page 1? variablepage2 =...

Hi On a multipage form, lets say with 2 pages. Is it possible to reference a value from a textbox on page 1 when code is executed due to the clicking of a command button on page 2? So far i have not been able to add arguments to the procedure: Private Sub cmdInput_Click() Any help would be...

Hi I've written a marco to perform a series of operations on some data. Is it possible to bring up a message, similar to a message box, excepting that it does not interfere with background calculations or require input from the user befor it can proceed. Ideally, is it possible that the...

Thanks, that works. :-)

Hi there I've got a form which runs on top of a spreadsheet. I use the form to add and edit entries. My problem is that whilst the form is running the spreadsheet is not accessible ie. can't click on any cells or scroll through the spreadsheet. Is it possible to make the background accessible...