Consulting

Results 1 to 5 of 5

Thread: Command button attached to Text box

  1. #1

    Command button attached to Text box

    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.

  2. #2
    VBAX Contributor Ivan F Moala's Avatar
    Joined
    May 2004
    Location
    Auckland New Zealand
    Posts
    185
    Location
    Not sure what you meant by movement but ............
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Quote Originally Posted by Ivan F Moala
    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

  4. #4
    VBAX Contributor Ivan F Moala's Avatar
    Joined
    May 2004
    Location
    Auckland New Zealand
    Posts
    185
    Location
    Hi Dave, I just grouped it and called it by name....same as your code.
    Have a look @ your code that I amended.
    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Quote Originally Posted by Ivan F Moala
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •