Hi all
Im trying to figure E.g. when A1 is empty i want it to equal a text.
A1 has a text "Quote No" in it permanently until other text is put in
Purpose so that they people know where to enter the applicable text.
Hi all
Im trying to figure E.g. when A1 is empty i want it to equal a text.
A1 has a text "Quote No" in it permanently until other text is put in
Purpose so that they people know where to enter the applicable text.
put 0 in all cells where you want a quote number
custom format as
#,##0.00;-#,##0.00;"quote number"
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
hi mate I putit in conditional formatting but does not work does the # equal a cell number
its a custom number format not a conditional format
You can use a TEXT BOX found on the Developer tab Controls Group.
Click on the Design Mode icon then click on Insert. Click on Text Box under Active X controls. Draw the box in cell A1.
A box with Sizing Handles will appear on the box that you have drawn. Right click this box and choose Properties. Click on Alphabetic tab. Click on the cell to the right of MAXIMUM LENGTH and enter the number of characters that you want to allow.
Click on the cell to the right of TEXT and enter the text that you want as default (Text before an entry is made) and hit enter. Click on the Categorized Tab, go to Font, Click on the button to the right and choose the font characteristics that you want.
Close the Properties box, click on the Design Mode icon to exit Design Mode.
The box should now be filled with the Default text and when you click in the box, you can make an entry.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks again for your replies
i have tried both methods but i still want "Quote No" with no cell input or when it is blank .
then you will need code to do that
something like
Please Login or Register to view this content.
Thanks that works !!!!!! i tried copying the code and it came back with a compile error
"ambigous name detected: worksheet_change"
i want another cell to equal something else but i get this error if i copy the code and change the cells and value
hmm see attached
thanks MartinDWilson you are the man!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks