PC Review


Reply
Thread Tools Rate Thread

Command buttons visiblle if data is correct

 
 
jajoke
Guest
Posts: n/a
 
      26th Jul 2008
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 With Quote
 
 
 
 
Wigi
Guest
Posts: n/a
 
      26th Jul 2008
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 With Quote
 
jajoke
Guest
Posts: n/a
 
      26th Jul 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Buttons/Data Entry DUNNER7 Microsoft Access 0 11th Jun 2009 09:10 PM
Command buttons, subforms and data entry =?Utf-8?B?ZWpmZXJyYXJv?= Microsoft Access 2 8th Jun 2007 02:01 PM
Command Buttons For Data Entry =?Utf-8?B?SmV0?= Microsoft Access Forms 6 19th Apr 2007 05:48 PM
Adding data from one form to another using command buttons =?Utf-8?B?TmljaHRTb0d1dA==?= Microsoft Access 2 19th Mar 2007 01:32 PM
Using command buttons to enter data =?Utf-8?B?TmljayBU?= Microsoft Excel Misc 1 12th Jan 2007 02:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:50 PM.