View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TerryK[_2_] TerryK[_2_] is offline
external usenet poster
 
Posts: 16
Default Bound column does not work after hiding form

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