Resize and put the button in correct position automatically

[luolovepi]

Dear all,

I made a worksheet which has a button at the beginning of each row. And I manually set the button as large as the cell.
And I use "wrap text" function in my excel worksheet. When I type a long text into the cell, the height of cell will be enlarged automatically.
However, the button size won't change and they won't move according to row, which means now the row with long long text may contain more than 1 buttons. That is not what I want. I want one row on button and the button will stick to a particular row.
I also want to resize my buttons according to the current cell size automatically.

Anybody knows how to do it?
Thank you very much!!

lolo^-^

 

[Sektor]

1. Right-click on button
2. Format Control...
3. Properties
4. Move and size with cells

 

[luolovepi]

Thank you Sektor!

regards,
lolo^^

1. Right-click on button
2. Format Control...
3. Properties
4. Move and size with cells

 

[luolovepi]

Hi Sektor,

Do you know how to adjust the area where button name is shown?
I want to button caption to be shown. Then button size is fixed. And the caption font is set to be 8 by myself. If font size is too small, the user can't recognise it. So I don't want to change the font size, but I want the full caption to be shown on the button. Is there any way to achieve this?

Thank you!

Best regards,
lolo^^

1. Right-click on button
2. Format Control...
3. Properties
4. Move and size with cells

 

[Sektor]

1. Right-click on button
2. Properties
3. Font (click on three dots in the right side)

 

[luolovepi]

Hi Sektor,
Thank you so much!
I have another question over copying a range of values to another range. These two ranges are in different workbook.
My code to do this is:

GLB_rngToPaste.Value = GLB_rngToCopy.Value

I confirm that GLB_rngToCopy has gotten the correct range of values.
But GLB_rngToPaste only received the first value of GLB_rngToCopy range.

I tested this kind of range to range assignment in the same worksheet, it could work. Can't it apply to ranges in different workbook or worksheet?

Hope you could help me if you happen to know it.
Thanks!!
Rgds,
lolo ^-^<!-- / message --><!-- edit note -->

1. Right-click on button
2. Properties
3. Font (click on three dots in the right side)

 

[Sektor]

GLB_rngToCopy.Copy GLB_rngToPaste

 

[luolovepi]

Hi Sektor,
I think copy can't be done like this. I couldn't solve the problem and then have changed my range copy to cell-to-cell copy already. And it works fine.

Thank you!

Best regards,
lolo

GLB_rngToCopy.Copy GLB_rngToPaste