Thread: Forms ComboBox
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Forms ComboBox
This'll work depending on how the code is called.

cmpcwil2 wrote:

Hi,
The following works..
Dim myDD As DropDown
Set myDD = ActiveSheet.DropDowns(Application.Caller)
MsgBox myDD.TopLeftCell.Address

Thanks for the help

--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=534463

--

Dave Peterson
Reply With QuoteReply With Quote