Userform and variable

G

Guest

Hi,

I have a userform, and you enter a number. Then based on the input the
userform runs code that uses the number. Usually I have the input box, where
the number is input, linked to the worksheet, then the code references the
worksheet

x = Sheets("Sheet1").range("a1").value

then it does the code, but is their a direct way to set variables using the
input in the userform.
 
B

Bernie Deitrick

Jeff,

It depends on the control, but something like

Variable = UserformName.ControlName.Value

..Value might be .Text, etc. depending on the control

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform and variables 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy sheets macro error 3
Creating a lookup in a userform 4
A Follow up to Userform Formating 1
Last item on a userform 2
Refresh Userform 1
Userform won't show when file re-opened 2

Top