Add bullet to current text

[Delta729]

Hi all, I could use some help with VBA. I'm sure this is probably really simple, but I don't know VBA at all. The below code works, but I need to change it so that it will only add a bullet point if in column D and the cell is NOT empty.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

[humdingaling]

try this

Please Login or Register  to view this content.

[Delta729]

Hi humdingaling, that does exactly what I asked but not what I actually need. (Completely my fault, I didn't think of everything).

I need it so it will add a bullet only to active cell or cells if in column C. If I happen to be in a cell in column B, then nothing should happen. (changed code to column C; and I thought by adding the "With Selection" to the code, the code would work.)

Please Login or Register  to view this content.

[Delta729]

Can anyone help me out?

Basically, I need to create a dynamic range of cells. For example, if I have a table in the first 200 rows with various text in each of the cells; and then I use my mouse to select C6:C10, the code will add a bullet point in front of the current text. However, say a minute later, I select just cell C15, I need the code to a bullet point to just that cell.

Any ideas where anyone can help me out?

[humdingaling]

shrugs
you jumping around all over the place to what you actually wanting


when you run the code...if Activecell is in Column C then run add bullet code if cells are not blank
but then your next post is about a specific range in column C or something of that matter

May i suggest you just have an input box and ask you to select exactly what cells you want to add bullet point to?

[humdingaling]

Please Login or Register  to view this content.

added extra query just in case you selected the wrong cells....because you cannot just "undo" easily