This is likely rather simple, I'm just not seeing the correct syntax.
When the workbook opens the form "NewProjectfrm" is set to automatically run, which it does.
The problem is the next two lines of code attempting to set the cursor in the form textbox "JWBNumber"
I can't think of the missing line I need to make this happen.
Thank you
Please Login or Register to view this content.
Try the above.Please Login or Register to view this content.
I think "NewProjectfrm.JWBNumber.SetFocus" needs to be in the userform_initialize code... that should give it focus when the form loads. And in there, change it to Me.JWBNumber.SetFocus
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I get an argument not optional error with the .select highlighted
Please Login or Register to view this content.
Maybe there's something left unsaid here perhaps this recent thread might help.
Then in userform:Please Login or Register to view this content.
Please Login or Register to view this content.
cytop sent me to one of my previous posts and I saw the difference there.
For whatever reason the .SetFocus was the issue. The textbox was actually active, just no visible cursor. However, clicking the tab button set the cursor to the next textbox.
Didn't notice the link was too an earlier thread by you... Oh well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks