LinkBack URL
About LinkBacks
Is it possible to use a formula in a pop-up window to make the message variable ?
Is it possible to use a formula in a pop-up window to make the message variable ?
Last edited by AliGW; 07-06-2021 at 12:50 AM.
You just killed me with that huge formula! I've never seen a formula like this! Is a monstrosity.
Have you consider using VBA?
Is not possible in Excel to assign a cell value to an object without VBA code. But, maybe I'm wrong!
Here is an example to spell numbers with VBA function. It can be used to became a comment content for current cell as event in your worksheet
https://support.microsoft.com/en-us/...8-69442cd55d98
Last edited by tanasedn; 07-01-2021 at 06:42 AM.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
I worked on the solution with VBA
The code for worksheet 2, as selectionChange event, is working for the B2:G4 range.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello tanasedn: your solution is just what the doctor ordered and works fine thank you.
The reason why I used the formula is because I am not really good with VBA and that formula was the only one I could find without using VBA.
Now all I have to figure out how to make the window showing the text bigger so the whole text is visible (and a few other things :-)
Good Day FDibbins
I just spend 30 minutes trying to put the cross link to mrexcel in here but I fail.
I cannot find any FAQ on how to do this so I give up
You have enough posts now that you should be able to just copy/paste the URL like hereOriginally Posted by gwminkl
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks