Use A Command Button more than one time
 

Quick Question, Hope someone can please help...I need to use a Command
Button. Users would click the button to insert a photo, from which
they choose from an insert dialog window, onto the sheet. The photo
would be placed at cell B4 automatically. Then, to insert a second
photo, the user would press the same Command Button and insert a
photo, but the photo would be placed at cell M4. The user would keep
going using the same command button, if they would need to insert more
photos. Can this be done with the programming using the same command
button? Can someone shout out some code maybe? Appreciate any
assistance.

Use A Command Button more than one time
 

I would think so--if you're careful.

Each time you add the picture, you could name the picture after its location:

Pict_B4
Pict_M4
Pict_whatever....

Then before you add any picture, you could look for pictures in that named
order. If pict_m4 doesn't exist, then that's where it would be added.



Bull wrote:

Quick Question, Hope someone can please help...I need to use a Command
Button. Users would click the button to insert a photo, from which
they choose from an insert dialog window, onto the sheet. The photo
would be placed at cell B4 automatically. Then, to insert a second
photo, the user would press the same Command Button and insert a
photo, but the photo would be placed at cell M4. The user would keep
going using the same command button, if they would need to insert more
photos. Can this be done with the programming using the same command
button? Can someone shout out some code maybe? Appreciate any
assistance.

--

Dave Peterson