View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gert-Jan[_2_] Gert-Jan[_2_] is offline
external usenet poster
 
Posts: 29
Default Checking some values in Workbook

I have a userform with some texboxes and comboboxes. If the user types or
select something, that data will be written to cells. (Sheet1A1, Sheet2B15,
Sheet3K29, etc.)
That input must be checked before it can be stored in the database. If the
cells doesn't contain proper data, the commandbutton1 must be disabled. I
would like to know how create a macro that checks all these specific cells.
Should I use select case?

Thanks for helping, Gert-Jan