Tying Combo Boxes or Check Boxes to Cells in Excel 3

[MarrowGenx]

I am having a problem with tying combo boxes or check boxes to cells. I have found the options to link the values cells to the value of the check or combo boxes. What I want to do is make a check box that covers the entire cell that it is linked to and make the appearance that they are the same object. I know that you can physically move the check or combo box over the cell to make it appear that way, but I am trying to create a VBA macro that will create these objects for me in the specified cell.

If I am not being specific enough, please tell me. I appreciate any help you can provide. Thanks for you help.

 

[SkipVought]

Hi,

Try this...

With Combobox1
   .Top = ActiveCell.Top
   .Left = ActiveCell.Left
   .Width = ActiveCell.Width
   .Height = ActiveCell.Height
End With

Actually, ActiveCell could be any cell reference.

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[MarrowGenx]

Skip,

Thanks, that helped out alot. I made a few changes to get the check box centered in the cell, but the code you recommended worked. I appreciate the help. Thanks.

Marrow

 

[DaleWatson123321]

Marrow,

Psssssssssssst... you forgot to "issue a STAR".

I see you've been a member for only about 1 week, so you're probably like most new members (myself included) who were not initially aware of this "proper method" of "saying thanks" to a contributor who provides help.

It involves simply clicking on the "Click here to mark this post as a helpful or expert post!" - located in the lower-left-corner of the contributor's posting.

Please do NOT issue a star for this "reminder" - I want to EARN stars in the normal way. Thanks.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Marrow,

I see you've logged in today.

Perhaps you didn't happen to notice the above posting, so please allow me to issue Skip a STAR on your behalf.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca