Double Click merged cell to display userform -

following on from previous post (http://www.excelforum.com/excel-prog...g-up-form.html) what if the selected cell is a merged cell (cell count is greateer than 1), what is the best solution to enable double click event on merged cell ?

Because you're now using the DoubleClick event (not the Selection event in which you might select a column or row that includes merged cells), couldn't you just get rid of the 'Target.Cells.Count > 1' clause and use:

Please Login or Register  to view this content.