Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a combobox with 3 options. When i choose an option i want to write me the option in the cell (6,5). although it works for the second and third option (Non Residential and combined) it does not work for the first one (Residential). Here it is my code. Could you please tell me what is wrong? If ComboBox3.ListIndex = 0 Then Worksheets("OUTPUT_CAT").Activate Cells(6, 5) = "Residential" End If If ComboBox3.ListIndex = 1 Then Worksheets("OUTPUT_CAT").Activate Cells(6, 5) = "Non Residential" Else Worksheets("OUTPUT_CAT").Activate Cells(6, 5) = "Combined" End If Thanks in advamce Angeliki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) |