Can you attach a sample file to better understanding of you query? Rajan.
-----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bob Sent: Jan/Sun/2012 03:24 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Concatinate I have a huge problem I just can not solve.I'm trying to concatinate several things. I have a user form with 15 optionbuttons. If specific optionbutton are clicked then do a certain thing.. Such as If optionbutton1 is clicked then put Always"350" Optionbutton1 is always "S" then whatever is in Label, Then IF optionbutton2 is selected then leave the "350", "S", whatever the label caption is and ad the other optionbutton and attach it to the first one . Such as 350S2Z5. So this would be 2 optionbuttons that were selected. 350 then S then 2 was the label, then Z was the next option button and 5 was the label. And put results in Sheet1 "J2" I have 15 combinations to do. Thanks for any Help!! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
