How to open msgBox and close UserForm if no data found

**tuongtu3** · 12-10-2012, 08:56 PM

Hi all,
I'm trying to open the workbook base on Cell value and I would like to open MsgBox and close UserForm if the file does not exsit.

Regards,
tt3

Please Login or Register  to view this content.

**tuongtu3** · 12-11-2012, 02:20 AM

Hi all,
Any help with this code please. The code is not correct but I posted there just for more details to show what I need.

I have UserForm with TextBox2
1. If TextBox is empty then show msgBox "Please enter Vehicle info" and exit UserForm.

2. If TextBox has entered with value then searching the file in drive "Y:\Testing\"
a_ Open the WorkBook if file name is valid and exit UserForm.
b_ Or Show msgBox "File not found" if file name is invalid and exit UserForm.

Regards,
tt3

**antoka05** · 12-11-2012, 04:28 AM

See attached file where I used this macro:

Please Login or Register  to view this content.

Regards,
Antonio

**tuongtu3** · 12-11-2012, 03:43 PM

Hi Antonio,
The code works on the sample and my worksheet too. Thank you very much for your time and help.
Can you explain why the code have 2 * at ".*xls*") and 1 * at ".xls*")? Does it work as same as without *?

Regards,
tt3

**antoka05** · 12-12-2012, 04:45 AM

I used jolly chars because excel can have extensions .xls or .xlsm or other... probably I was wrong to use first asterisk, I could use ".xls*".
Regards,
Antonio