Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Box connect to a cell
Hello I'm a novice at this ... I created a userform - then I added the
button to the spreadsheet and it works. But how Do I add/connect the answer I select to cell B7 of the spreadsheet . Example if someone selects Type A I want type A to show in cell B7 , if Type B is selected then Type B will be in cell B7 . so on and so on Thanks! Sub ShowDialog() With UserForm1.ListBox1 .MultiSelect = fmMultiSelectSingle .RowSource = "" .AddItem "Type A" .AddItem "Type B" .AddItem "Type C" .AddItem "Type D" .AddItem "Type E" .AddItem "Type F" .AddItem "Type G" End With UserForm1.Show End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Box connect to a cell
Hi
add a button to the form. Private Sub CommandButton1_Click() Range("B7").Value = ListBox1.Value End Sub select a value, click the button. Regards FSt1 "Marilyn" wrote: Hello I'm a novice at this ... I created a userform - then I added the button to the spreadsheet and it works. But how Do I add/connect the answer I select to cell B7 of the spreadsheet . Example if someone selects Type A I want type A to show in cell B7 , if Type B is selected then Type B will be in cell B7 . so on and so on Thanks! Sub ShowDialog() With UserForm1.ListBox1 .MultiSelect = fmMultiSelectSingle .RowSource = "" .AddItem "Type A" .AddItem "Type B" .AddItem "Type C" .AddItem "Type D" .AddItem "Type E" .AddItem "Type F" .AddItem "Type G" End With UserForm1.Show End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect cell to a numbet on the Internet | Excel Discussion (Misc queries) | |||
How do I connect a cell reference to a picture? | Excel Discussion (Misc queries) | |||
How do I connect two cells? If one cell changes the other changes | Excel Discussion (Misc queries) | |||
how can I connect data in cell C to data in cell D? | Charts and Charting in Excel | |||
How do I connect cell color to bar chart color? | Charts and Charting in Excel |