x404.co.uk
http://x404.co.uk/forum/

Add macro to drop down menu items in Word 2003
http://x404.co.uk/forum/viewtopic.php?f=4&t=1908		 Page 1 of 1
Author:  forquare1 [ Wed Jul 22, 2009 10:41 am ]
Post subject:  Add macro to drop down menu items in Word 2003
Hi all,

I need to program a drop down menu in Word 2003 to change the colour of a cell in a table. I can program a button to change the colour of a specified cell, and I can do the same when the drop-down menu looses focus, but I've no idea how to make individual items in the menu to trigger a macro...

If that isn't possible, then a backwards idea would be to set the text, then when the drop down menu looses focus it calles a macro which checks what the colour is, but I don't know how to refer to the menu...

Any ideas?

Thanks very much,
Ben
Author:  AlunD [ Wed Jul 22, 2009 10:44 am ]
Post subject:  Re: Add macro to drop down menu items in Word 2003
Stupid Question I know, but does it have to be word? could it be excel? - conditional formatting is there to use.
Author:  forquare1 [ Wed Jul 22, 2009 11:10 am ]
Post subject:  Re: Add macro to drop down menu items in Word 2003
Yes, I guess it could be Alun.
What I'm doing really shouldn't be done in a word processor or a spreadsheet IMO, but what's all I've got to work with :P

I'll pull the data out ot the Word file and shove it in an Excel file.

Some pointers from there would be good :)

Thanks,
Ben
Author:  AlunD [ Wed Jul 22, 2009 11:18 am ]
Post subject:  Re: Add macro to drop down menu items in Word 2003
select teh cell, range of cells you want then, format menu, conditional formatting wizard does it for you from there on.
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/