Search results for query: *

silly me this works yay ! thank you all Dim c As Control Dim s As String Dim I As Integer If UserForm1.chk1 = True Then Count = Count + 1 End If If UserForm1.chk2 = True Then Count = Count + 1 End If If UserForm1.chk3 = True Then Count = Count + 1 End If If UserForm1.chk4 = True Then...

Dim c As Control Dim s As String Dim I As Integer If UserForm1.chk1 = True Then Count = Count + 1 End If If UserForm1.chk2 = True Then Count = Count + 1 End If If UserForm1.chk3 = True Then Count = Count + 1 End If If UserForm1.chk4 = True Then Count = Count + 1 End If If UserForm1.chk5 =...

MajP - I am assuming you are referring to Andy's solution , the problem is i have more check boxes for other functions that the MSForms.CheckBox goes through unless there is a way to specify to these 5 specific check boxes

MajP & zelgar - you both are absolutely correct , i was looking at this from a math problem stand point with 120 possibilities but as you both stated its 31 combinations with the order not mattering. Also there will be no "5 choose 0 = 1" so only 31 strongm - using my prior example Check box...

Thanks everyone that replied ! Strongm- yep that's exactly how you come up with 120 combinations with 5 possible variables Softhemc - for the sake of clarity let say Check box 1 gives me a msgbox "a" Check box 2 gives me a msgbox "b" Check box 3 gives me a msgbox "c" Check box 4 gives me a...

Hi Guys , I'm new to vba and coding in excel and ive gotten myself into quite the pickle Simply put , i have 5 check boxes on my user form thereby creating 120 possible combinations which each will give me a combination msgbox of the text fields the check boxes are in front off. . Is there...

My idea was to have attachmate replace the needed cells in the excel file and have the user manual open the word document with all the corresponding infomaruon that was pulled into excel used in the mail merge . Yes it will be one letter at a time . As I do not want more than one letter at a...

Thanks Skip for the advice , i have put those techniques to use and am revamping the code with this advice. Will post the solution when i am done for critique.

Hi guys n gals I am currently trying to pull data off attachmate into a excel file . Without opening the excel file for a mailmerge letter. I have come across some examples of this on here but unfortunately they have not posted the code with the solution. (...

Hi Guys Newbie to attachmate here . learnt everything about it off theses forums *thanks for the great work ! * so to the problem at hand .... I have written a simple code (below) to pull some client numbers off coordinates on attachmate and copy it into cells in excel. The marco works on...