How to create object to follow selected cells in vba

G

geniusideas

I wanted to use VBA to create text box which is follow active cells
for example when I click or select cells( A1) and run the macro the
text box will appeared inside or nearer to this cells and if i click
or select cells (F5) and run this macro the text box appeared inside
or nearer to this selected cells. pls help
 
J

Jim Thomlinson

Why not just use

Data -> Validation

Leave the validation at Any
Add an input message...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
How to create a variable selected range 9
How to count drawing object (text box) in vba 4
Altered pasting functionality 3
How to activate Sheet2? 5
Excel VBA help: Text file formatting 19
Naming non-contigent cells with vba 5
VBA Excel how to assign name in variable range 4

Top