Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check the path for validity Souny Excel Programming 4 September 18th 09 01:50 PM
How can I show a validity by a prompted symbol in colour? Maray Excel Worksheet Functions 1 February 3rd 09 10:47 AM
How do I add a control check box to control other checkboxes? JGarland Excel Worksheet Functions 1 September 18th 08 12:26 PM
=VLOOKUP validity Greg H Excel Programming 3 January 22nd 07 12:38 PM
Selecting control on userform with part of control name (set question) Keith Excel Programming 4 January 10th 07 02:24 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"