View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
jose luis jose luis is offline
external usenet poster
 
Posts: 1
Default Could You Explain the difference?


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