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


 
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
RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE Joe Excel Worksheet Functions 13 May 27th 08 01:52 AM
Checking values in 2 columns BRob Excel Worksheet Functions 4 May 1st 08 02:32 PM
Checking a column of values against another one BRob Charts and Charting in Excel 1 May 1st 08 09:18 AM
Checking on two values Johannes B. Excel Discussion (Misc queries) 4 April 22nd 05 06:49 PM
checking values in a cel solo_razor[_8_] Excel Programming 2 September 18th 03 01:37 PM


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

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

About Us

"It's about Microsoft Excel"