Move Button To ActiveCell

[marreco]

Hi

Is possible move Button to activecell?

Please Login or Register  to view this content.

thanks

[TMS]

Sure. This will move the command button to the active cell (the cell selected when you click the button)

Please Login or Register  to view this content.

Regards, TMS

[marreco]

Display

Runtime error '424'
the object is required

Yellow line

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[marreco]

Hi TMS.

Very good!!!!!!!

Thank you!!!

[TMS]

You're welcome. Thanks for the rep.

[TRLWNC]

I have a slightly different problem, and I'm just getting into programming, so I don't know what to actually use from above.

I would like to press a command button and place the cursor/active input cell at a specific location so that information can THEN be input into those cells.

I have looked this up, and "select" appears to be the wrong thing to learn. This code looks nice, but I get a syntax just copying and pasting. Which line do I change to make this work for my workbook?

[TMS]

@TRLWNC: in this instance, you would use Select.

For example,

Please Login or Register  to view this content.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[TRLWNC]

Sorry. I forgot. Thanks for the reply.

[TMS]

@TRLWNC: no worries