An Advanced Tickbox?

Amnesia_180

New Member
Joined
Jan 25, 2005
Messages
14
Hey.
Im new to the board, so just saying hi! :biggrin:

Here is my problem:
I am having a bit of trouble with something.
i have 2 sheets.
"Sheet1" and "Sheet2"
Customer details are entered into sheet1 via a userform.
This includes addresses, amount of money, totals etc.
Then, when a button is pressed it copies some of the data into "sheet2". Which is just a long line of things.
It then inserts another row ready for the next set of data to be entered.

However, I want a tick box entered onto the end of each line. If it is not ticked, all the text will be red showing they have not paid the fees. If the tickbox is checked, the text for that line goes green.

Thank you for any help you can give me.
Thanks
Amnesia
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,899
Use conditional formatting with the linked cell property of the tickbox.


HTH


:cool:
 

Forum statistics

Threads
1,148,528
Messages
5,747,221
Members
424,069
Latest member
kamkwok1hh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top