View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Userform Control validity check

Ken,
Thanks for the feedback!
I'll look into the AfterUpdate issue with the listboxes.
I did think you'd need a methodology to track what users do in terms of
deselecting already selected items.

I was thinking a 'Static' var could be used to store whether the count
was incremented already. This could take appropriate action if the list
item[s] were deselected leaving the listbox in a 'requires input'
state. This is doable, I just need time to work on it.

I think you had the right idea about this using your If..Then..Else
constructs. I'm considering a modified version of that which will track
the input state of each control.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc