PDA

View Full Version : Solved: Using combobox value in a file path



owen_1987
10-14-2011, 05:47 AM
Hi all,

My aim is to open a folder using a (variable) file path selected using a combobox (in a userform) to select the appropriate file.

I know this is wrong but this is what I've got so far:
FileName:="C:\Documents and Settings\Desktop\Batches\" & UserForm1.ComboBox1 = Value & "0001.emf", _

Do I just have the wrong description or is it much more complicated?

Thanks

John Wilson
10-14-2011, 06:17 AM
Would need to be
& UserForm1.ComboBox1.Value

The form would need to be still open of course.

owen_1987
10-14-2011, 06:49 AM
Thanks very much John, worked perfectly