Hi,

here is the way to draw a textbox on a sheet.

ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, 95.25, 124.5, _
59.25, 67.5).Select

I have seen that their are other possible notices on the position, by
example 95#. What means # in this case? Are their other notices available?

txs
Piet

# means that the constant (or variable) should be treated as double instead of a
long.

Variables that are explicity declared as double:

dim myVar as double
or
dim myVar#

Can hold much bigger numbers than longs.

Take a look in VBA's help for "Data Type Summary" and you'll see the limits of
each type.

You can also use:
% to treat a constant as an integer (or Dim myVar1%)
@ for currency
& for Long
! for Single
$ for String


Personally, I declare variables using words--not by using type-declaration
characters. I can't remember them (for the most part).



piet wrote:

Hi,

here is the way to draw a textbox on a sheet.

ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, 95.25, 124.5, _
59.25, 67.5).Select

I have seen that their are other possible notices on the position, by
example 95#. What means # in this case? Are their other notices available?

txs
Piet

--

Dave Peterson