Forum Discussion
Solved
Obtain data from a cell with lots of paragraphs
Cool, So I have multiple questions I need help with regarding formulas and macros. ok, So I have a cell that contains paragraphs of text. Imagine I'm a teacher, and each student gave multiple par...
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
Update:
OMG, I figured out what you told me to do. finally!
from https://support.microsoft.com/en-us/office/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f
Now I have a new issue.
So I like things organized, and renamed the modules from module1,2,3,4,5 to understandable ones.
click on module > view > properties windows > rename on the bottom left side.
This, kinda made all the shortcuts for my macros break.
Basically, An exact problem this guy had -> https://stackoverflow.com/questions/59105782/how-can-i-make-my-macro-shortcut-key-work-again
kay, so I renamed it all with an extra "s", so its FormatTranscriptss, CleanTranscriptss, ExtractPartss
It's all working now.
but like, I can't get its name back to without the additional "s", and my OCD hurts.
Any solutions?
If I try, I get "This will reset your project. Shall we Proceed?"
Saying "confirm" again breaks it back to PERSONAL.XLSB!FormatTranscripts.FormatTranscripts
Which is broken, as shown in the URL link above. Sigh.
Please advise
OMG, I figured out what you told me to do. finally!
from https://support.microsoft.com/en-us/office/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f
Now I have a new issue.
So I like things organized, and renamed the modules from module1,2,3,4,5 to understandable ones.
click on module > view > properties windows > rename on the bottom left side.
This, kinda made all the shortcuts for my macros break.
Basically, An exact problem this guy had -> https://stackoverflow.com/questions/59105782/how-can-i-make-my-macro-shortcut-key-work-again
kay, so I renamed it all with an extra "s", so its FormatTranscriptss, CleanTranscriptss, ExtractPartss
It's all working now.
but like, I can't get its name back to without the additional "s", and my OCD hurts.
Any solutions?
If I try, I get "This will reset your project. Shall we Proceed?"
Saying "confirm" again breaks it back to PERSONAL.XLSB!FormatTranscripts.FormatTranscripts
Which is broken, as shown in the URL link above. Sigh.
Please advise
The names of the modules aren't really important, you can use anything you like, as long as the names are not the same as those of macros or custom functions.
- Hi again,
I might need your help again.
https://techcommunity.microsoft.com/t5/excel/vba-text-based-help-pseudo-code-provided-hard-difficult-expert/m-p/3602073
Posting it here, if others ever see this post, they'll find another related question to a similar scenario. - Oooh, so that's why I got the errors and it broke. okok.
I now use an underscore in module names now.
instead of FormatData for both module & macro names. I've changed to,
module-name: Format_Data
macro name: FormatData
shortcut: Cntrl + Shift + F
It's all fixed now. Thank you so much!