Posts by zoog25

Re: Coding Assistance With UserForm Using a Checkbox

thanks. I'm new to using userforms and checkboxs.
I'll eliminate the first part and just try the second then you suggestion. I'll let you know if it works or not.

Hello All,

I'm trying to develop a Userform with text and a checkbox. I'm having problem with the coding.
Here is the coding i have so far.

Public r As String








Private Sub CheckBox1_Click()
    If cbRev.Enabled = True Then
        r = 1
    End If
End Sub




End Sub




Private Sub cmdAddEntry_Click()




Dim ws As Worksheet
Set ws = Worksheets("Master")




With ws
    If r <> 1 Then
        ActiveCell.Offset(0, 1).Value = txtJob.Value & " " & txtScope.Value & ".pdf"
    Else
        ActiveCell.Offset(0, 1).Value = txtJob.Value & " " & txtScope.Value & " " & "(Rev).pdf"
    End If
End With




'clear the data
Me.txtScope.Value = ""
Me.txtJob.Value = ""




End Sub

Part of the code was taken from an example from online search. My problem is with the checkbox. How do I set it to code that when it is checked then it uses the second value line and unchecked it uses the first line value and then sends it to the cell next to the one being used to call the userform.

Quick setup. Column D holds pull down menu. One option is called "Scope Report". If say cell D2 is used and Scope Report is pull up then the userform comes and the user fills in the information into txtjob and txtscope and either checks rev or not. The user then clicks add entry and cell E2 gets either the first value or second value.

That is where I'm having problems, locating the checkbox info so the program and send the right info.

Hello All,

Here is my situation, I have created an excel program that takes scan files and renames them. The scanned files fall under several different categories with the same file name structure so i developed an excel sheet for each type. The situation is that the naming is getting more and more complicated with additions and options to each type so I though a better solution would be to take each sheet and develop a UserForm that would allow me to input the information like before and then add checkboxes to the form that allows me to select the different options available to a user.

Now Attached you will find a sample of one run i did with the old style. I developed a UserForm Example for the Scope Report. The problem is that i'm lost in trying to use the userform and programming. The userform should popup when the name in column d is pulled from the drop down menu. Ie. Scope Report would bring up the Scope Report form. The user would then fill in the information and then either select the checkbox or not. The information is then transfered to column E next to the cell that you just made ur selection.

If you know anything about Userforms, please help me. I feel that if i can get an example of making one work then i can manipulate that information for the other forms that may contain no more then three checkboxes. Thank you for any help that you can provide.forum.ozgrid.com/index.php?attachment/52584/