Okay got that figure out too lol using strTemplate = UserForm1.ComboBox1.Text
Probably not pretty but it works.
Last thing I need help with here is if there's any way to remove the file name type in the combobox using my above code? Right now it will list things as "Default.oft" etc, I'd like...
Okay, so I have a crude solution to display the files in the combobox using
With ComboBox1
Dim MyFile As String
My File = Dir("Directory Path)
Do While Myfile <> ""
.AddItem MyFile
MyFile = Dir()
Loop
End With
End Sub
Now I need some assistance in selecting the correct template in the folder...
I suppose I wasn't quite clear. I'm having trouble figuring out how to dynamically update a combobox with a list of templates in a file system directory.
As of right now I can use .AddItem and manually add in items to the drop down and then use Case 0, 1, 2 etc to modify a template string to...
Hi, I have a few issues I'm needing help with but this is the biggest one for me right now.
I'm trying to create something where a user will press a button and have a list of templates in a shared drive folder pop up, which they can select from. The list needs to automatically refresh every...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.