Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combination box to cell
How do i get my choice from a combobox on a user form to a cell in the
worksheet additionally how to do this with a number of cells in one row then repeat for the row below. do i need anyhitng in the cells to accept the .value = "whatever" TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combination box to cell
Chris,
Private Sub ComboBox1_Change() Sheets("Sheet1").Range("A1") = ComboBox1.Value End Sub HTH Henry "Chris A" wrote in message s.com... How do i get my choice from a combobox on a user form to a cell in the worksheet additionally how to do this with a number of cells in one row then repeat for the row below. do i need anyhitng in the cells to accept the .value = "whatever" TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combination box to cell
Your a STAR, I can see me using this one quite alot at the moment, people
seem to struggle with 20+ cells to fill in but can hadle a form with 5 at a time, so from everyone at work, Cheers, lots good times going you way. Chris "Henry" wrote in message ... Chris, Private Sub ComboBox1_Change() Sheets("Sheet1").Range("A1") = ComboBox1.Value End Sub HTH Henry "Chris A" wrote in message s.com... How do i get my choice from a combobox on a user form to a cell in the worksheet additionally how to do this with a number of cells in one row then repeat for the row below. do i need anyhitng in the cells to accept the .value = "whatever" TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom cell formats combination of numbers and text | Excel Discussion (Misc queries) | |||
Formula by combination of worksheet name and cell | Excel Discussion (Misc queries) | |||
combination functions in one cell | Excel Worksheet Functions | |||
Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
How can I enter a cell in excel with hotkey or combination off key | Excel Discussion (Misc queries) |