On Row Click event show dropdown in the Row

[Ranjani]

hi,

I have some rows in my sheet locked and some unlocked rows.

When user clicks on a unlocked row I should be able to enter some information.

I am suppose to populate some dropdowns in that row for him to choose.

How can this be done??

I know when a user clicks a row worksheet change event is call. I can write a function in the worksheet change event to populate values in the dropdown...

I went through some articles, and they say it can be done by hiding and unhiding rows. Does anybody knows how to go about it.

Thanks

[royUK]

Why not use Data Validation?

http://www.excel-it.com/data_validation.htm

[Ranjani]

The dropdown values are going to come from an XML...Moreover on click of the row i need to show the dropdown..make it a kindaa of editable row...

[Ranjani]

Thanks

I did use Data Validation. I call a method called GetVendors which retrieves from an XML and returns a string

I am adding a list which contains values of the string returned from the xml (refer 5th line)

and then making the list as dropdown (refer 6th line).

Please Login or Register  to view this content.

Thanks again