DSNTNOENUF
New Member
- Joined
- Aug 3, 2015
- Messages
- 32
I am using the following formula to extract data between carrots and it works flawlessly.
=MID(B3,FIND("^",B3)+1,FIND("^",B3,FIND("^",B3)+1)-1-FIND("^",B3))
What I would like to do is to be able to bring up VBA and paste code to add this function to my selectable list (such as fuzzyvlookup). The formula referencing cell values would have to be replaced with active.cell
Can anyone assist me in this final step? If I am getting really picky would there by a simple userform that could be switched on and off that would ask for the beginning character and ending characters to search between so a not so adept user did not have to fiddle with the code? I say on/off because if it was a large carrot or pipe file I would set the user form visibility to false and just define the character.
Cheers!
=MID(B3,FIND("^",B3)+1,FIND("^",B3,FIND("^",B3)+1)-1-FIND("^",B3))
What I would like to do is to be able to bring up VBA and paste code to add this function to my selectable list (such as fuzzyvlookup). The formula referencing cell values would have to be replaced with active.cell
Can anyone assist me in this final step? If I am getting really picky would there by a simple userform that could be switched on and off that would ask for the beginning character and ending characters to search between so a not so adept user did not have to fiddle with the code? I say on/off because if it was a large carrot or pipe file I would set the user form visibility to false and just define the character.
Cheers!
