but people,
i get the error when i call a component after component creation

for example

1. oleobject - create combobox
2. call combobox in format - msgbo
worksheets(XXX).ComboboxName.Name


BUT if i have two SUBs, where first sub is OleObject creation o
combobox,
and second is Calling component in format ( above )

then all works normally !!!! :(


i cant understand where is the difference, and why it is ,,,,

why i cant component after component is created ???

--
Mare
-----------------------------------------------------------------------
Marek's Profile: http://www.excelforum.com/member.php...fo&userid=1376
View this thread: http://www.excelforum.com/showthread.php?threadid=26911