PDA

View Full Version : macro to delete and underline in a table cell



tammytutone
02-18-2010, 05:06 PM
I have a template that has a table in it. In four of the cells I have a control that is a drop down box. There are 3 choices in the drop down box and i put 6 blank spaces in case the user doesn't want any of the 3 choices. I put an underline code around the control so that the choices would be underlined after the template is completed, but I don't want the blank spaces to show up as an underline, so I need a macro to associate with this template that will search the cells and look for 6 blank spaces and delete the underline. Can anyone help or is there another way to do this? http://www.techsupportforum.com/images/smilies/1-grin.gif Thanks in advance.

macropod
02-20-2010, 12:55 AM
Hi Tammy,

See reply at: http://lounge.windowssecrets.com/index.php?showtopic=772461

How many other forums have you posted this query in? If there are any others, please notify them of the above solution.

lucas
02-20-2010, 08:21 AM
Tammy, If you want further help here I advise you to read this:

Why it is common courtesy to link to cross posts (http://www.excelguru.ca/node/7)

Don't abuse the people who offer you free help.

macropod
02-20-2010, 09:49 PM
Hi Lucas,

In the link I posted, I'd already pointed Tammy to the excelguru site's advice, which Tammy's acknowledged, so I didn't think it necessary to emphasize the point with yet another reference to it. I don't think any abuse was intended.

lucas
02-21-2010, 08:44 AM
I'm sorry if I sounded harsh.

The point I was trying to make is that if you continue to cross post without providing a link, many people will start ignoring your requests for help.