Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking command button size to cell proportions?
I am pretty new to excel programming but have had a recent
success. I have a command button that sits in cell C2 (I have sized the command button so that it is the same size as C2). The command button runs a quick snippet of code to add one to the value of C3. What I would like to do is to have the command button resize to match cell C2 if cell C2 size is changed. Eg., I change column C's width with the mouse, the command button changes. I am also wondering if the best way to go about this is to somehow link the cell to the command button in the beginning, like what happens when data validation is used to create a combo box in cell. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking command button size to cell proportions?
Hi,
Right Click the command button and select Format control and from the Tab Properties select move and size with cells. (I think this is the default behaviour - atleast in XP) Abdul Salam -----Original Message----- I am pretty new to excel programming but have had a recent success. I have a command button that sits in cell C2 (I have sized the command button so that it is the same size as C2). The command button runs a quick snippet of code to add one to the value of C3. What I would like to do is to have the command button resize to match cell C2 if cell C2 size is changed. Eg., I change column C's width with the mouse, the command button changes. I am also wondering if the best way to go about this is to somehow link the cell to the command button in the beginning, like what happens when data validation is used to create a combo box in cell. Thanks in advance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking command button size to cell proportions?
Thanks! Just what I was looking for, and I wouldn't have
found that for a long time. -----Original Message----- Hi, Right Click the command button and select Format control and from the Tab Properties select move and size with cells. (I think this is the default behaviour - atleast in XP) Abdul Salam -----Original Message----- I am pretty new to excel programming but have had a recent success. I have a command button that sits in cell C2 (I have sized the command button so that it is the same size as C2). The command button runs a quick snippet of code to add one to the value of C3. What I would like to do is to have the command button resize to match cell C2 if cell C2 size is changed. Eg., I change column C's width with the mouse, the command button changes. I am also wondering if the best way to go about this is to somehow link the cell to the command button in the beginning, like what happens when data validation is used to create a combo box in cell. Thanks in advance. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell by command button | Excel Worksheet Functions | |||
Command button font size changes | Excel Discussion (Misc queries) | |||
Command button depending on Cell Value | Excel Discussion (Misc queries) | |||
Font Size in Command Button | Excel Discussion (Misc queries) | |||
How do i clear a cell using a command button? | Excel Discussion (Misc queries) |