MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Box on User Form


Posted by Romeo on January 24, 2002 9:41 AM

I have a Combo Box on a UserForm. I would like to know how to link the Combo Box to the data in the worksheet (Range A1:A20) and how to link the combo box selection value to a particular cell, say C10

Being new to excel, help is much appreciated

Thanks in advance


Posted by dominic on January 24, 2002 10:04 AM

in the properties of your combo box, change

'ListFillRrange' to be A1:A20

'LinkedCell' to be C10

Posted by Romeo on January 24, 2002 11:06 AM

Re: Thanks, But did not find


Hi,
ListFillRrange and Linked Cell could not be found in the Property List

Please help

Posted by dominic on January 24, 2002 11:20 AM

Re: Thanks, But did not find

oops, i was using a combo box directly on a worksheet. It looked easy, but using actual forms is that little bit outside of my ability. Hope I didn't cause any grief! Hi, ListFillRrange and Linked Cell could not be found in the Property List


Posted by Juan Pablo G. on January 24, 2002 1:02 PM

Re: Thanks, But did not find

Try instead for (1) RowSource, and for (2) ControlSource

Juan Pablo G. : : Hi, : ListFillRrange and Linked Cell could not be found in the Property List


Posted by Romeo on January 24, 2002 10:44 PM

It is great, Thanks (NT)

Juan Pablo G. : oops, i was using a combo box directly on a worksheet. It looked easy, but using actual forms is that little bit outside of my ability. Hope I didn't cause any grief!