hi,

There is already a Module in the other workbook called custForm1 which
contains the following to open the Userform3:

Sub Z()
UserForm3.Show
End Sub

I just am not sure of the syntax now, becausae I am getting an error message
witrh the following:

Application.Run "Z"

Am I missing something?

Thanks in advance,
geebee

"Bob Phillips" wrote:

What you need to do is have a small macro in that other workbook that shows
the userform, then run that macro using Application.Run.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"geebee" wrote in message
...
hi,

I am trying to open a userform in another workbook and change the value
for
one of the comboboxes in that Userform... Here is what I have..

Workbooks.Open "E:\Path\filename.xls"
UserForm3.Show vbModal
c003.Value = "test"

It is not working!

Can someone help?

Thanks in advance,
geebee