Locking worksheet labels and box sizes

Similar Threads:

1.dynamic size of label, and depending on size label position of tex

Hi, I am creating a form, which reads depending of a choice from an excel 
worksheet the value for label caption, right next to this label a textbox is 
shown. Because the size of the label caption is dynamic, the position of the 
textbox must shift left or right on order to read the complete label caption. 
By doing so the size of the form might also need to change. How to create 
such? there are 10 possible labels and textboxes, which are shown depending 
on the choice. This last part is already working.

Regards
Gerard

2.dynamic size of label, and depending on size label position of

Jacob,

Thx

Gerard

"Jacob Skaria" wrote:

> Try setting the below property of Label
> 
> AutoSize property to True 
> OR
> WordWrap property to True 
> -- 
> If this post helps click Yes
> ---------------
> Jacob Skaria
> 
> 
> "noord453" wrote:
> 
> > Hi, I am creating a form, which reads depending of a choice from an excel 
> > worksheet the value for label caption, right next to this label a textbox is 
> > shown. Because the size of the label caption is dynamic, the position of the 
> > textbox must shift left or right on order to read the complete label caption. 
> > By doing so the size of the form might also need to change. How to create 
> > such? there are 10 possible labels and textboxes, which are shown depending 
> > on the choice. This last part is already working.
> > 
> > Regards
> > Gerard

3.How do I re-size the chart axis label text box

The text that I type into the y-axis label is always cut off. For example, I 
would like the label to say:

Cell density
(cells/cm2)

But instead, it looks like

Cell densi
(cells/cm

I cannot get around this problem by choosing a smaller (or even larger) font 
or by turning a long one-line entry into two lines of text. 

I just upgraded to Excel 2003 Small Business Edition. This did not seem to 
be a problem with Excel 2000.

Thanks,
Jen

4.Word mailing labels - CreateNewDocument creates labels with wrong page size and margins

Hello,

I am trying to automate Word (needs to be downward compatible to Word 2000, 
so I'm using msword9.olb library) to do a mail merge to mailing labels.

I'm using VC++, but I've also tried this with VB, and the same problem 
occurs.
I have directly put in the code found in article 258512, and the same 
problem occurs... so this should be easy to reproduce.

The problem is this:

When I create the mailing labels using automation, it creates a gigantic 
page of 11.22" x 12.05" size.  The margins are all wrong, too.
I am trying to create a standard Avery 5160 label, and I pass in the code:

  oNewDoc = oMLabel.CreateNewDocument( COleVariant( "5160"), vtOptional, 
vtOptional, vtOptional, vtOptional);

And what I get in the end is a large page full of labels 4 across and 12 
down.  I tried to change the page size directly, but the labels is still 4 
across and 12 down, which means it's not really Avery 5160.

I tried the equivalent in VB using Word 2007 type library, and I got the 
same result.

My data source is a comma-delimited text file, but that shouldn't matter... 
the merging is fine.  It's just that the page size and the margins are all 
wrong.

If you have any idea what is going on, and what I can do to fix it, I would 
appreciate it very much.

Thank you.

--Daniel

5.Worksheet Labels as Combo Box Selections

Good afternoon --

I would like to set up a combo box using the labels of the worksheets as the 
options from which the user selects.  So, if I had a contiguous set of 
worksheets -- Smith, Jones, Thompson, for example -- how could I do that?

Can anyone help with how to do that?

Thanks in advance.

6. How to rezize data label box in pie charts (label wraps to two lin

7. Change check box size and fount size?

8. Comment Box Size = 125% Fill Picture Size