Thread: Could You Explain the difference?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
  
Posts: 1,758
Default Could You Explain the difference?
One of the differences between parts of our suggestions is that I used a
combobox from the control toolbox toolbar. Jake used a dropdown/combobox from
the Forms toolbar.



jose luis wrote:

Thank you so much Jake and Dave for your prompt, complete and
understandable response (for novices like myself). I learned the
difference, and solve my programming problem. Hope to read you around
and be able in the near future to help others as you do today.

Thanks again

Jose Luis

jose luis Wrote:
Can you help understand why this code works:


Code:
--------------------
Sheets(1).Shapes("ComboBoxA").Select
Selection.ListFillRange = "lista2"
--------------------



and this one don't:



Code:
--------------------
Sheets(1).Shapes("ComboBoxA").ListFillRange = "lista2"
--------------------



Thank you all


Joe

--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=381040

--

Dave Peterson
Reply With QuoteReply With Quote