Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a cell in a worksheet from a userform
I have a userform with option buttons on it. I am trying to accomplish the
fact when a user clicks on this particular option button it will fill a textbox with data from a cell on a worksheet. How do I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a cell in a worksheet from a userform
A simple example (2 options):
Private Sub OptionButton1_Click() TextBox1 = Sheets("Sheet1").Range("A1").Value End Sub Private Sub OptionButton2_Click() TextBox1 = Sheets("Sheet1").Range("A2").Value End Sub You should be able to modify this idea to meet your needs. "Adam" wrote: I have a userform with option buttons on it. I am trying to accomplish the fact when a user clicks on this particular option button it will fill a textbox with data from a cell on a worksheet. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiline textboxes from userform to worksheet cell | Excel Programming | |||
Userform cell reference help | Excel Programming | |||
how do I link Textboxes in a userform to a Cell in a Worksheet? | Excel Programming | |||
Taking Data of cell from worksheet to a userform window | Excel Programming | |||
Anchor a Userform to a cell in the worksheet | Excel Programming |