How to create object to follow selected cells in vba

  • Thread starter Thread starter geniusideas
  • Start date Start date
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
 
Why not just use

Data -> Validation

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