IF checkbox is marked adjust script

**Jamesraywebber85** · 07-18-2023, 02:41 PM

I have a code that pulls info from a Userform to generate a text string. I have 3 checkboxes at the bottom of my userform that I want to include in the text string only if they are checked it would generate a new text string & attach it to the clipboard so all my agent has to do is paste & it is done. Here is my code:

Please Login or Register  to view this content.

And here is an image of my Userform.
Screenshot 2023-07-18 142330.png

As I have the code now this is an example of data that will generate the script: "L-IF Conversion - Created order #12345 and closed order #98765 to add RTS." If lets say the 2nd checkbox is checked then it would display as "L-IF Conversion - Created order #12345 and closed order #98765 to add RTS. Please add a cancellation fee."

OR

If check box 2 & 3 were checked it would show as:
"L-IF Conversion - Created order #12345 and closed order #98765 to add RTS. Please add cancellation fee. Add swap fee."

**PCI** · 07-18-2023, 03:35 PM

See next code

Please Login or Register  to view this content.

**Jamesraywebber85** · 07-18-2023, 04:29 PM

It works pretty good, however I believe this needs to be an IF statement, I'm just not sure how it should flow.

Here is the code that I have modified to show correctly.

Please Login or Register  to view this content.

The issue I have is if Checkbox1 is the only one selected then it should show as:
SWAP - Created order #12345 and closed order #98765 to add RTC. This is/was a city service account that I adjusted pricing, please review billing.

If Checkbox1 & Checkbox3 is selected then it would show:
SWAP - Created order #12345 and closed order #98765 to add RTC. This is/was a city service account that I adjusted pricing, please review billing. Add swap fee.

If Checkbox2 & Checkbox3 is selected then it would show as:
SWAP - Created order #12345 and closed order #98765 to add RTC. Add Cancellation fee. Add swap fee.

If checkbox3 is only selected then it would show as:
SWAP - Created order #12345 and closed order #98765 to add RTC. Add swap fee.

and so on. Basically each checkbox would add a certain string of text onto the WkStg string. Thank you so much for any help that you are able to provide!

**PCI** · 07-18-2023, 04:45 PM

Okay
Another way

Please Login or Register  to view this content.

**ByteMarks** · 07-20-2023, 07:20 AM

Using a function.

Please Login or Register  to view this content.

IF checkbox is marked adjust script

LinkBack

Thread Tools

Rate This Thread

Display

IF checkbox is marked adjust script

Re: IF checkbox is marked adjust script

Re: IF checkbox is marked adjust script

Re: IF checkbox is marked adjust script

Re: IF checkbox is marked adjust script

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help making marked cell stay put while i sort list taking info from marked cells.

[SOLVED] Error 424 on script to change the status of a ActiveX checkbox based on a cell value

[SOLVED] script to set linked cell on active x checkbox

Button to know what checkbox are marked

Delete Cells if Checkbox not Marked

Script to auto-adjust y-axis min

[SOLVED] Checkbox to be marked with a cross rather than a tick

Bookmarks

Bookmarks

Posting Permissions