Switching Between workbooks while Form is running on one of the workbook

[khader]

Hi,

I have a VBA program tht runs a VB form ,The user requirement is to switch between workbooks while they r using forms tht r already open and r avaliable in the taskbar.I am unable to do this as the form is running and it cant switch to another workbook tht is already open.But they are able to view the file if they open the file from Start->Run-> .

Could any of you share ur expertise asap??

[Ecniv]

Originally posted by khader
Hi,

I have a VBA program tht runs a VB form ,The user requirement is to switch between workbooks while they r using forms tht r already open and r avaliable in the taskbar.I am unable to do this as the form is running and it cant switch to another workbook tht is already open.But they are able to view the file if they open the file from Start->Run-> .

Could any of you share ur expertise asap??

1) VB form... pop up from excel or actual vb.?
2) What code are you using atm?
3) Proper variables/objects or the selection/range object?
4) Use a drop down or two on the form to list open/available workbooks/sheets.

[khader]

Originally posted by Ecniv
1) VB form... pop up from excel or actual vb.?
2) What code are you using atm?
3) Proper variables/objects or the selection/range object?
4) Use a drop down or two on the form to list open/available workbooks/sheets.

Hi Ecniv,
I am running the Vb form on excel by programming it using VB for Application (VBA) my code reads something like this

start form()
userform1.show()
end sub

userform1.activate()
listbox1.additem("a")
listbox1.additem("a")
listbox1.additem("a")
end sub

-------

while running the userform1.activate
i would like to open up another excel file ,if you can gimme ur email id i can send in the file so thth the scenario is a bit clear?

my email id is [email protected]

Thanks

Khader

[khader]

Originally posted by Ecniv
1) VB form... pop up from excel or actual vb.?
2) What code are you using atm?
3) Proper variables/objects or the selection/range object?
4) Use a drop down or two on the form to list open/available workbooks/sheets.

Hi ,

I seem to have fixed this problem ,I loaded the form in modeless format and used the workbook change events . thanks a lot anyways,

Khader