Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform combo box
Hi,
Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform combo box
I depends on what you think the normal rules are.
right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform combo box
Thank you Tom!
Thats perfect Thanks "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
Tom,
Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
Souny,
Try using the Change event rather than the click event. The initial recalc seems to be firing the click event code, but should not fire the change event. HTH, Bernie MS Excel MVP "Souny" wrote in message ... Tom, Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
Bernie,
Thanks for your response. I tried with Change event, and the problem still exists. I don't know why. Please help. "Bernie Deitrick" wrote: Souny, Try using the Change event rather than the click event. The initial recalc seems to be firing the click event code, but should not fire the change event. HTH, Bernie MS Excel MVP "Souny" wrote in message ... Tom, Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
Does the combobox list range contain formulas rather than values?
At the end of it all, you could change your macro code to look at some other enabling value that you store in a named cell somewhere... for example If Range("DisableCombo").Value < "Enabled" Then Exit Sub HTH, Bernie MS Excel MVP "Souny" wrote in message ... Bernie, Thanks for your response. I tried with Change event, and the problem still exists. I don't know why. Please help. "Bernie Deitrick" wrote: Souny, Try using the Change event rather than the click event. The initial recalc seems to be firing the click event code, but should not fire the change event. HTH, Bernie MS Excel MVP "Souny" wrote in message ... Tom, Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
You may want to just bite the bullet and drop the linkedcell and rowsource and
replace them with code. Souny wrote: Tom, Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with a combo box in a worksheet
Dave,
Thanks for your response. Could you help me with the code? "Dave Peterson" wrote: You may want to just bite the bullet and drop the linkedcell and rowsource and replace them with code. Souny wrote: Tom, Could you help me one thing? I have a combo box in one of my worksheets, and the code for the combo box is also in the same worksheet "Sheet1". Basically, the code will execute the lines based on the value selected (from clicking) from the combo box. Somehow, the code automatically executes when the file is opened. I have tried many ways, and I am still having problems. I don't understand why the code will automatically execute when the file is opened. Below is my code structure. Private Sub cboCode_Click() Application.ScreenUpdating=False Select Case cboCode.Value Case "Selection1" 'Do the following Case "Selection2" 'Do the following Cash "Selection3" 'Do the following Case Else 'Do the following End Select Application.ScreenUpdating = True End Sub Please help. Thanks. "Tom Ogilvy" wrote: I depends on what you think the normal rules are. right click on the combobox and select properties. in rowsource, the link for the dropdown list, put something like Sheet1!A1:A30 in Control source (the link for the result) sheet2!B9 -- Regards, Tom Ogilvy "Andy the yeti" wrote: Hi, Due to some superb help from these groups I have almost achieved what I wanted to do using a userform, I have one last hurdle now that involves using a combo box on a userform. Do these follow the rules of normal of combo boxes in regards to a cell link and input range? If so could I have some pointers please on how to set up the properties? Thank you very much Andy -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Initialize & combo box values | Excel Discussion (Misc queries) | |||
Userform combo box triggering macros | Excel Discussion (Misc queries) | |||
UserForm and combo box to another sheet | Excel Discussion (Misc queries) | |||
How to get a range of values into a combo placed on USERFORM? | Excel Programming | |||
Combo Box in userform | Excel Programming |