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

maybe...

give excel (or the ole object) some time to do it's chores,
by including a doevents statement?

Create

DoEvents

Assign



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Marek wrote:


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 - msgbox
worksheets(XXX).ComboboxName.Name


BUT if i have two SUBs, where first sub is OleObject creation of
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 ????