liam.mccaffrey
|
| posted on 18/4/07 at 11:30 AM |
|
|
excel and VB
I want to have a drop down list in excel with about 3 options.
which depending on what option is selected will change the colour of all text in that row to grey.
i already have quite a lot of complicated conditional formatting so would like to do this another way
VB seems the way to go, but having never used it i don't know where to start
any advice, i sort of need tog et this done sharpish so i dont really have time order books and stuff
Thanks
Liam Mc
Build Blog
Build Photo Album
|
|
|
|
|
Mr Whippy
|
| posted on 18/4/07 at 12:11 PM |
|
|
I think you can do this with just excel, type 'drop-down' into the help search thing and there's stuff on it there. Should be easy
to do, I also use conditional formatting of the coloured bars for histograms, very handy
Fame is when your old car is plastered all over the internet
|
|
|
lsdweb
|
| posted on 18/4/07 at 12:23 PM |
|
|
Hi Liam
Try recording a few macros of you changing row colours etc.. Then go into VB and have a look at the code - it's pretty easy then!
If you're really desperate, send me the sheet and I'll try and do it for you.
Regards
Wyn
|
|
|
liam.mccaffrey
|
| posted on 18/4/07 at 12:50 PM |
|
|
cheers guys, ill try those out
Build Blog
Build Photo Album
|
|
|
