ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Icons wthin an Excel spreadsheet (https://www.excelbanter.com/excel-programming/388385-using-icons-wthin-excel-spreadsheet.html)

sharonm

Using Icons wthin an Excel spreadsheet
 
I have a spreadsheet with numerous lines of Data (something like below) where
if the user double clicks on any one of the first three columns in a row a
letter is generated in Word based on the data contained in that row. I am
using the Before Double Click event to generate the letter which is working
fine.

x x x __Data__________________
x x x __Data__________________
x x x __Data__________________

I would like to have an icon, like the print preview icon, in Columns 1, 2,
and 3 on just the rows with data in the spreadsheet without degrading the
performance of the macro. I was thinking maybe adding them during run time as
data was added to a line?

Would anyone have any suggestions? Any help would be greatly appreciated!

Thanks.





All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com