Combobox release

B

Brett

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
 
F

FSt1

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
 
B

Brett

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
 
B

Brett

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top