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

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

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

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

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