On Row Click event show dropdown in the Row

**Ranjani** · 03-09-2009, 01:19 PM

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** · 03-09-2009, 01:23 PM

Why not use Data Validation?

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

**Ranjani** · 03-09-2009, 01:32 PM

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** · 03-09-2009, 02:47 PM

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).

On Error Resume Next
    Dim R As Range: Set R = Range(ActiveCell.Address)
    Dim strList As String: strList = GetVendors
     With R.Validation
    .Add xlValidateList, xlValidAlertStop, xlBetween, strList
    .InCellDropdown = True
End With

Thanks again