Combboxes and Testboxes

  • Thread starter Thread starter James
  • Start date Start date
J

James

I have a form with 2 ComboBoxes which add together to form
both parts of a file URL.

eg. CB1 CB2
My Documents Spreadsheet1
Spreadsheet2


When the desired parts are highlighted a CommandButton is
pressed leading to another form. This second form has a
textbox and I would like it to state the file's address.

eg My documents\Spreadsheet1

Another CommandButton is pressed which then activates the
desired file.

Is this possible? Can anyone help me?

Thanks in Advance

James
 
Public Sub CommandButton3_Click
sStr = CB1.Value & CB2.Value
userform2.Textbox1 = sStr
Me.hide
userform2.Show
Unload me
End Sub

in Userform2

Public Sub CommandButton1_Click
Workbooks.Open Textbox1.Text
Unload me
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset All Command Buttons on an Excel UserForm 20
Sheet Protection Question 6
UserForm Combobox DropButtonClick Event Bug? 3
Userform combobox matchrequired = True; error with no selection 4
First textbox in form not accepting input properly 4
message box to check value 3
Pass variables to Worksheet_SelectionChange 3
Dynamic Command Button Caption 1

Back
Top