Hello
I need help guiding me with a Userfom i have .
IŽd like to select a mouth in a combobox that opens a excel file after checking the file is not in use , what i have is this:
but the code does nothing, it works only when i aply the code on a comand botton.
Please Login or Register to view this content.
is there a different case using it with a combobox ?
thanks
Code can be simplified but I see no reason why it wouldn't work with the Change-event.
The only thing I can think of is that you clicked on the name that was selected before. You need to select another value then the one being displayed in the CB.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
thank you
it works fine now ...also thank you to trim my code since it will be usefull when file directory changes to modify quickly
you're welcome and thanks for rep+.
sorry
i just find out that when the file is alrady open instad to show form YAESTAABIERTO.Show and close the workbook
excel still would opend it as a copy and does not show the YAESTAABIERTO.Show
Is PLATINUM the userform where the CB is in ?
Try moving the Unload to the end of the code.
What does your IsFileOpen code look like ?
it is working perfect moving the unload to the end of the code
thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks