PC Review


Reply
Thread Tools Rate Thread

Accessing Form's Values from Invoking Sub

 
 
eBob.com
Guest
Posts: n/a
 
      11th Jan 2008
Writing my first ever VBA macro. My macro needs to access the value which
the user typed into a text box on a form.

UserInput.Show
MsgBox "max value is " + UserInput.tbxMax.Text

The resulting message box shows that UserInput.tbxMax.Text returned a null
(or maybe blank) value but I certainly did type something into the text box!

The form's OK button's code just does an Unload Me. Is that the problem.
Are the control's values lost because of the Unload? If so what should I
have done to remove the display of the form and return control to the
invoking sub but still retain the user entered values?

I don't know that what I tried should have worked, but it all made sense
based on my VB.Net experience.

Thanks, Bob


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Accessing File Message when invoking event procedure =?Utf-8?B?RGFuIE93YnJpZGdl?= Microsoft Access VBA Modules 1 15th Apr 2005 05:09 PM
Accessing User values in Outlook form Bill Le May Microsoft Excel Discussion 0 5th May 2004 10:52 PM
re: Accessing form values of a webpart Jim Buyens Microsoft Frontpage 3 26th Jan 2004 11:46 PM
Accessing Lookup values in a form? COLLIER Microsoft Access Forms 2 30th Nov 2003 10:03 PM
Accessing the values of form controls on worksheets in Excel 2000 robbinma Microsoft Excel Programming 2 28th Aug 2003 08:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:24 PM.