Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup command not giving the correct result | Excel Worksheet Functions | |||
Colour formatting using command buttons and comparing data. | Excel Discussion (Misc queries) | |||
Using command buttons to enter data | Excel Discussion (Misc queries) | |||
Correct syntax for use Replace command via DDE? | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming |