I was here once before and I'm back; Here's my quandary:

What I want to do is build a filename (and save it of course) using what the user puts into a txtbox. In that filename I have the user select one of three option buttons and a number of checkboxes. In other words this filenname is built from 3 variables; one string; one conditional (the result of the option button) and the result(s) of the check boxes.

Any help? Thank you.

(i'd upload a pic of the form in *.bmp format but cannot

4 Years
Discussion Span
Last Post by Reverend Jim

Add a string value to each and just add them all together -

''In the top of your code window just after Option Explicit, the following...

Dim strOne As String, strOption As String, strResult As String, strAll As String

In each controls events (checkbox_click, Option_click etc events)

strOne = TheStringSet

If Option1.Value = True Then
strOption = TheOptionSelectedHere
ElseIf Option2.Value = True Then
End If

I'm sure you get the idea.

''Before you do the file name, add the all together...
strAll = strOne & "/" & strOption & "/" & strResult

''If it was a file path you were putting together for instance, you will have something like - FilePath = strAll

You might want to use a backslash instead of a forward slash as a separator.

Votes + Comments
As always the reverend is here to catch my mistakes, thanx. :)
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.