Luis Diaz
asked on
Excel VBA: keep & remove text based on character & add-in
Hello experts,
Following the question: Question 29176080
which allows me to keep and remove text based on character. I need some help to add to my add-in to be able to swiftly use the procedure on a daily basis.
-Reference procedure to be added in the add-in located at: EE29176080.xlsm
-Reference add-in LD-add-in.xlsm
It should be added at: Keep_Remove_Text_Based_On_ Char
Located at:
If you have questions, please contact me.
Thank you in advance for your help.
LD-add-in.xlsm
EE29176080.xlsm
Following the question: Question 29176080
which allows me to keep and remove text based on character. I need some help to add to my add-in to be able to swiftly use the procedure on a daily basis.
-Reference procedure to be added in the add-in located at: EE29176080.xlsm
-Reference add-in LD-add-in.xlsm
It should be added at: Keep_Remove_Text_Based_On_
Located at:
If you have questions, please contact me.
Thank you in advance for your help.
LD-add-in.xlsm
EE29176080.xlsm
ASKER
Hi Bill,
Thank you very much for this.
I tested but I am having a strange issue (complicated to identify). When I launch the procedure from my LD-add-in.xlsm the procedure works perfectly.
When I save the xlsm file as xlam file in order to use it across multiple files (as I do as always). I have the following error message:
This is not the case for a similar procedure which use userform. Probably if we take as a reference variable definitions of the one that works, we are able to solve the problem.
What do you think?
Regards,
Luis.
Thank you very much for this.
I tested but I am having a strange issue (complicated to identify). When I launch the procedure from my LD-add-in.xlsm the procedure works perfectly.
When I save the xlsm file as xlam file in order to use it across multiple files (as I do as always). I have the following error message:
This is not the case for a similar procedure which use userform. Probably if we take as a reference variable definitions of the one that works, we are able to solve the problem.
What do you think?
Regards,
Luis.
ASKER
Sorry, thought that was changed, should be:
LD-add-in.xlsm
»bp
Select Case True
Case optKeepBefore
Keep_Remove_Text_Based_On_Char_Logic 1, txtColumns.Text, txtDelim, chkBackup, ActiveSheet
Case optKeepAfter
Keep_Remove_Text_Based_On_Char_Logic 2, txtColumns.Text, txtDelim, chkBackup, ActiveSheet
Case Else
MsgBox "Please select at least one option", vbOKOnly + vbInformation, "No Action Chosen"
Exit Sub
End Select
LD-add-in.xlsm
»bp
ASKER
Thank you Bill, I will test it and let you know.
ASKER
Hi Bill,
I just took the add-in that you posted at:#a43050781, remove the previous xlam file and save the xlsm as xlam to use it across workbooks as I do always.
The routine is there:
Private Sub declaration is not causing the problem?
I just took the add-in that you posted at:#a43050781, remove the previous xlam file and save the xlsm as xlam to use it across workbooks as I do always.
The routine is there:
Private Sub declaration is not causing the problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Bill.
LD-add-in.xlsm
»bp