asked on 5/16/2011

inserting text excel

Hi:
In excel I have a comments field.
There are a range of comments I can put in but for example the logic is as follows:
"if cell a2 > 0 then comment is "urgent"". This applies to every cell in column a, down to a200.
Because the comment cell is also used for typed text then any formula will be overwritten.
So I need somehow to be able to click a button and excel will scroll down the comment column, inserting the appropriate text where the criteria is met.
Is this possible?

Thanks!

Microsoft Excel

Last Comment

nike_golf

5/16/2011

Kalpesh Chhatrala

5/16/2011

you can add button from following link
http://www.wikihow.com/Create-a-Custom-Macro-Button-in-Excel

and command button event from below link
http://www.excelforum.com/excel-programming/754435-run-command-button-click-event-on-open.html

Richard Teasdale

5/16/2011

ASKER

Thanks for that kalpesh2804 - but it is not the button itself I am struggling with; it is the VBA.
Say the comment field is in column B. And the criteria field is column A. Then my code needs to read "while Ax < A200 then for each A where value > 0 then set value of B to "Urgent"".
I could always cheat and have a column C for manually typed comments but space is limited on the live sheet and the print small enough as it is!
Thanks

ASKER CERTIFIED SOLUTION

nike_golf

5/16/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Richard Teasdale

5/16/2011

ASKER

Just like that, thanks!
I actually need to change a different column - so column B changes, not A - but you have given me the platform!
Thanks again!

nike_golf

5/16/2011

Glad I could help.

NG,