Thanks for the reply. When I click help on the catostrophic error it just says that either an external error exists or something in the code...(can't remember what the tail end of it was)
The userform has mostly text boxes, drop down lists. The only code i have in the userform initialize procedure is like the example that follows:
With cboMWRNumber1
.AddItem "1107-90"
.AddItem "1180-90"
.AddItem...
brenty66
Last Activity: Jan 21 '08, 02:57 AM
Joined: Jan 16 '08
Location:
-
Thanks for the reply. The userform has mostly text boxes, drop down lists. The only code i have in the userform initialize procedure is like the example that follows:
With cboMWRNumber1
.AddItem "1107-90"
.AddItem "1180-90"
.AddItem "1182-90"
.AddItem "1185-90"
End With
Which places the information in the drop down lists. There isn't...Leave a comment:
-
Excel VBA - ERROR TRAPPING HELP!!!
I have a userform used as an interface to store information on excel spreadsheets. I have put a decent amount of work into it to this point and all of a sudden I am getting a catastrophic error message. It pops up every now and then when I try loading the userform. When I select OK it will then show a runtime Error 361 "Can't load or unload object" At this point it will usually close out of excel and ask to send an error report. Sometimes... -
Lets say you have a button on your userform that when pressed by the user will go to the next tab on your userform. The code you would have on your button click procedure is as follows:
MultiPage1.Valu e = 1
Note: the first page has a value of 0, the second page has a value of 1 and so on. Set the value = to which page you want it to take focus on.Leave a comment:
-
Write out all 15 of the questions you want on the form. Then place your "Next" button after each question. On the properties window (left side) where it says visible: True (do this for each question and button). Change them to false.
. Encode into your btnNext click procedure this:
If btnNext = True Then
lblQuestion.vis ible = True
btnNext2 = True
End If
If btnNext2 = True Then
...Leave a comment:
-
Excel VBA question (Userform search field)
I have a userform that is used as an interface for information stored on excel spreadsheets. The user enters bits of information into fields on the userform which are place on the corresponding worksheet. I would like to have a txtBox that is used as a search field. When the user enters a number in the field it will search through column A of worksheet 1 for the value that was entered into the field. Once it is found I would like it to return...
No activity results to display
Leave a comment: