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

...ComboBox1_AfterUpdate() x = Userform.ComboBox1.Value If (x = "0") Or (x = "1") Or (x = "2") Then 'do nothing Else '***** Userform.ComboBox1.SetFocus '***** MsgBox "An invalid entry has been made. Please make sure...

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! :-)

...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 "" MsgBox "The required field 'Business Trade Name' is empty." End Select...

Thanks Skip Working now

thanks doesnt work though

...This does it. My problem is that i am wanting to use named ranges instead of ["=Sheet1!$C$2:$C$10"]. I have attempted the following: *** ActiveWorkbook.Names.Add Name:="target1", ReferToR1C1:="=Sheet1!$C$2:$C$10" ActiveChart.SeriesCollection(1).Values = "" & target1 & ""...

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...