Im trying to create a data form to upload details to spreadsheet. I have created the form in VBA but when I try and play it i get the error message "run time error 424 object not found." I cant seem to find the problem in the code and have stared at it for so long I feel a bit like an eskino staring at the snow. Any suggestions will be welcome below is the code
Please Login or Register to view this content.
Last edited by GingerJah; 05-12-2010 at 06:31 AM.
Welcome to the Forum
Add Code tags before the moderators get you!!...
Forum Rules
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button
Maybe it is the sheet name
Please Login or Register to view this content.
And maybe indicate what line is giving you the error message.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
It is not displaying which line is generatingthe error message
I suspect one of your control names is wrong. When you get the error, press Debug then press f8 repeatedly to step through the code line by line and see where the actual error is.
Everyone who confuses correlation and causation ends up dead.
Try this
Please Login or Register to view this content.
You would also save a lot of grief if you were to put your Combo List on a lookup sheet and call the items from there. Either in the properties pane, or via code.
Also in Private Sub cmdOK_Click()
You have two "End If"s without an If statement, try this
Please Login or Register to view this content.
Cheers
Thanks for that the line showing as the error are
the first two after the button commands, they are
Private Sub UserForm_Initialize()
txtName.Value = ""
I'd double check the control name then. If you delete theline and typePlease Login or Register to view this content.you should get a list of the properties (including control names) that start with 't' so check if yours is listed.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks