Command buttons visiblle if data is correct
 

Hi,

Can someone help me out with this:
On a worksheet I have 25 rows with 10 culloms to be filled out with
validated data.
If the data in the 10 culloms for one row is filled out correctly a command
button for that row should be visible and enabled in the same row. If the
data in 1 or more culloms for that row is not valid the button should not be
visible in that row.
If the data in all rows is correct I should see 25 buttons.
--
Jackie

Command buttons visiblle if data is correct
 

Why do you use command buttons? And not something easier like IF functions
and Conditional formaating?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"jajoke" wrote:

Hi,

Can someone help me out with this:
On a worksheet I have 25 rows with 10 culloms to be filled out with
validated data.
If the data in the 10 culloms for one row is filled out correctly a command
button for that row should be visible and enabled in the same row. If the
data in 1 or more culloms for that row is not valid the button should not be
visible in that row.
If the data in all rows is correct I should see 25 buttons.
--
Jackie

Command buttons visiblle if data is correct
 

The worksheet I 'm talking about is only for input of data.
If the data in one row is correctly filled out this data has to be copyd to
certain cells of a another worksheet to be printed only one time. If that
worksheet is printed a chekbox has to be set as true.
--
Jackie


"Wigi" wrote:

Why do you use command buttons? And not something easier like IF functions
and Conditional formaating?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"jajoke" wrote:

Hi,

Can someone help me out with this:
On a worksheet I have 25 rows with 10 culloms to be filled out with
validated data.
If the data in the 10 culloms for one row is filled out correctly a command
button for that row should be visible and enabled in the same row. If the
data in 1 or more culloms for that row is not valid the button should not be
visible in that row.
If the data in all rows is correct I should see 25 buttons.
--
Jackie