Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox release
When I select a value from a dropdown list for a combobox, is there a way to
make the combobox release automatically and update it's linked cell. At the moment the combobox entry is still highlighted and I have to click elsewhere to get the release. Regards, Brett |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox release
hi when you select at item from the combo box, the combo box takes focus and keeps it until focus is shifted ie click somewhere else. as a suggestion you could use the change event to shifted focus to the sheet say to the linked cell or where ever you thnk is best. assume B8 is the linked cell....... Private Sub ComboBox1_Change() Range("B8").Activate End Sub regards FSt1 "Brett" wrote: When I select a value from a dropdown list for a combobox, is there a way to make the combobox release automatically and update it's linked cell. At the moment the combobox entry is still highlighted and I have to click elsewhere to get the release. Regards, Brett |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox release
Thanks for that. It's actually more or less what I've been doing, but I
thought there might be a setting in the properties to solve it. oh, well. Regards, Bret "FSt1" wrote: hi when you select at item from the combo box, the combo box takes focus and keeps it until focus is shifted ie click somewhere else. as a suggestion you could use the change event to shifted focus to the sheet say to the linked cell or where ever you thnk is best. assume B8 is the linked cell....... Private Sub ComboBox1_Change() Range("B8").Activate End Sub regards FSt1 "Brett" wrote: When I select a value from a dropdown list for a combobox, is there a way to make the combobox release automatically and update it's linked cell. At the moment the combobox entry is still highlighted and I have to click elsewhere to get the release. Regards, Brett |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox release
Hi again
Activating a cell doesn't seem to work unless I put a msgbox display (or maybe something esle) in between. However, what does work very nicely is UF0_QCP.TextBox35.SetFocus (TextBox35 is just a heading) where UF0_QCP is the userform that contains the troublesome combobox. Regards, Brett "FSt1" wrote: hi when you select at item from the combo box, the combo box takes focus and keeps it until focus is shifted ie click somewhere else. as a suggestion you could use the change event to shifted focus to the sheet say to the linked cell or where ever you thnk is best. assume B8 is the linked cell....... Private Sub ComboBox1_Change() Range("B8").Activate End Sub regards FSt1 "Brett" wrote: When I select a value from a dropdown list for a combobox, is there a way to make the combobox release automatically and update it's linked cell. At the moment the combobox entry is still highlighted and I have to click elsewhere to get the release. Regards, Brett |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox release
hi
sorry. i thought you have a sheet combo box. had i known you had a form i would have suggested something different. maybe you end solutions. but the focus think still hold true. sorry of missunderstanding. regards FSt1 "Brett" wrote: Thanks for that. It's actually more or less what I've been doing, but I thought there might be a setting in the properties to solve it. oh, well. Regards, Bret "FSt1" wrote: hi when you select at item from the combo box, the combo box takes focus and keeps it until focus is shifted ie click somewhere else. as a suggestion you could use the change event to shifted focus to the sheet say to the linked cell or where ever you thnk is best. assume B8 is the linked cell....... Private Sub ComboBox1_Change() Range("B8").Activate End Sub regards FSt1 "Brett" wrote: When I select a value from a dropdown list for a combobox, is there a way to make the combobox release automatically and update it's linked cell. At the moment the combobox entry is still highlighted and I have to click elsewhere to get the release. Regards, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cursor Release | Excel Discussion (Misc queries) | |||
Is this release buggy? | Excel Discussion (Misc queries) | |||
Release Memory | Excel Discussion (Misc queries) | |||
Excel 12 New Release | Excel Discussion (Misc queries) | |||
how do i release memory | Excel Programming |