Bound column does not work after hiding form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some comboboxes that are filled from an arra
When I select an item from the drop down list the value of the bound column appears in a textbo

I then hide the form to allow the user to do some work on a spreadshee
I then display it again with the UserForm.Show comman

Problem
Although all information in the comoboxes is retained - the bound column no longer work
It appears that the cursor has moved one space to the right and the string is no longer recognized as being in the dropdown list
If I edit the value manually and backspace once - the bound column works

Any ideas how fix this

TerryK
 
TerryK said:
It appears that the cursor has moved one space to the right and the string is no longer recognized as being in the dropdown list.
Click to expand...

Sounds like someone has used SendKeys " " ???
What happens if you move the focus from the combobox before hiding the form?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Bill,
There is no SendKeys code in the project. Is this something that Excel would do behind the scenes? If so is there a method to disable it?

TerryK
 
Bill,
I forgot to respond to your question
"What happens if you move the focus from the combobox before hiding the form?"

This does not appear to be the issue. There are about 12 comboboxes on the form and they are all affected in the same manner. So which control has the focus does not seem to come into play.

TerryK
 
TerryK said:
There is no SendKeys code in the project. Is this something that Excel would do behind the scenes?
Click to expand...

No.
Sorry. Out of ideas.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Bill,
Thanks for your input. Your thoughts gave me a new command and a solution.
This is crude but it works.

FormInput.ComboBoxVersaLam1.Text = Range("d16")
FormInput.ComboBoxVersaLam1.SetFocus
SendKeys "{bs}"

TerryK
 
Back
Top