PDA

View Full Version : [SOLVED] Command button attached to Text box



Desert Piranha
08-03-2005, 11:43 PM
Hi,

Someone here said you guys are the best coders in the world. So here is one for you.
Have a text box that moves around the sheet with me, on mouse clicks or arrows etc.
I want to attach one or more Command buttons to the box.

I have tried Grouping a command button to it, and it did group, but it affected the
movement of the text box. What i am looking for is to still have the movement of the
box after the Command button is attached.

thx
Dave
P.S. This is a very good site.

Ivan F Moala
08-04-2005, 01:17 AM
Not sure what you meant by movement but ............

Desert Piranha
08-04-2005, 09:49 PM
Not sure what you meant by movement but ............
Ivan,
You did an excellent job. More than i expected. Question is how did you do it?

I think you just "grouped" them right? When i tried that it wouldn't work correctly.

By movement i meant the "box following the active cell around the sheet".
When i grouped them i lost that movement.

Did you have to do anything else?

thx
Dave

Ivan F Moala
08-05-2005, 01:08 AM
Hi Dave, I just grouped it and called it by name....same as your code.
Have a look @ your code that I amended.

Desert Piranha
08-05-2005, 02:35 AM
Hi Dave, I just grouped it and called it by name....same as your code.

Have a look @ your code that I amended.
Thanks Ivan. I'm on a different puter right now, will check out the code later.

You are indeed awesome!

Thanks a lot.
Dave