Share via

ActiveX Listbox Linkedcell

Anonymous
2014-09-22T01:00:48+00:00

I need to create a dynamic linked cell for an activeX list box. I would like it to link to the cell I select instead of a fixed cell. Does anyone know how to do this? Thanks in advance

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2014-09-22T11:56:53+00:00

Hi, can you post a sample of what you want to achieve, do you need an ActiveX Listbox or just a cell with a drop down and based on what you select another dropdown list will show up, if that is what you are looking for look into Debra Videos and examples on data validation dependent lists

http://www.contextures.com/xlDataVal02.html

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2014-09-29T14:24:45+00:00

    Thanks! I used a data validation list and it works quite well. I have been away from Excel for a while and had forgotten about data validation lists. Thanks again! :)

    Dave

    Was this answer helpful?

    0 comments No comments