Hi,

Thanks for the help for my SQL question!!!

I have two more questions

(The application is Excel VBA. All controls are in a user form)

1. For ComboBox, how can I prevent users from entering any value other
than those in the listed choices in the ComboBox? User can only select
the value from the list.

2. There are several Text Boxes in my application. Users need to enter
numeric data in these boxes. The function required is if users enter any
character, e.g. 300k, there will be an error message and the focus
should fix in that TextBox (users can't move from this box to other
controls until they enter a valid value).

Thanks

Ming



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!