| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create object to follow selected cells in vba
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create object to follow selected cells in vba
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Table with the range of selected cells | Excel Programming | |||
| Create a picture from cells, a chart, or an object | Excel Discussion (Misc queries) | |||
| create a thin border around the selected cells | New Users to Excel | |||
| Create a new Excel file with selected cells | Excel Discussion (Misc queries) | |||
| how to create a toolbar button to set selected cells to wrap text | Excel Discussion (Misc queries) | |||
Linear Mode
