How to create object to follow selected cells in vba

's Computer Specifications

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

's Computer Specifications

Why not just use

Data -> Validation

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

Jim Thomlinson

"geniusideas" wrote:

> 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
>
>

's Computer Specifications

On Jun 10, 1:30*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com> wrote:
> Why not just use
>
> Data -> Validation
>
> Leave the validation at Any
> Add an input message...
> --
> HTH...
>
> Jim Thomlinson
>
> "geniusideas" wrote:
> > 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

i need to use object that why i can't use data validation

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a picture from cells, a chart, or an object	=?Utf-8?B?U2FuZHdpemFyZA==?=	Microsoft Excel Misc	2	8th May 2007 03:04 PM
create a thin border around the selected cells	=?Utf-8?B?Q2hhbmRyYSBMZWU=?=	Microsoft Excel New Users	1	24th Jul 2006 01:53 PM
Create a new Excel file with selected cells	john	Microsoft Excel Discussion	1	19th Jul 2006 02:18 AM
Create a new Excel file with selected cells	john	Microsoft Excel Misc	2	18th Jul 2006 12:28 AM
how to create a toolbar button to set selected cells to wrap text	=?Utf-8?B?c3RldmVndWViZXJ0?=	Microsoft Excel Misc	1	9th Dec 2005 12:34 AM