Thread: open Userform in Another workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] binesh.r@gmail.com is offline
external usenet poster
  
Posts: 3
Default open Userform in Another workbook
Userform3.c003.value= "test" works

geebee wrote:

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

Reply With QuoteReply With Quote