Conditional Format for Cell Borders

**CA_ME** · 09-10-2008, 02:33 PM

I need an experts opinion here.

I know the VBA code to create a border around a cell. How do I condition the code to have the border present only when the cell contains data. ie, cell empty = no border, cell with data = border. In this case, contents of the cell are irrelevent.

2nd question: on an autorun macro, is there a comand that will pause the macro so I can paste a jpeg file into the worksheet then continue running the macro till the end?

**Kenneth Hobson** · 09-10-2008, 04:54 PM

Best to post 2 threads for two questions.

For (1), just add two conditional formats.

For (2), make a userform modeless. When the user presses, OK button, it will continue.