Below is the code I used to add a comment from text in another cell. I want the comment to pull from a range of cells so it shows up as a list. In the attached file, I want the comment to show I3 & I4 on separate lines. Thanks.
Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Since there are only two cells involved and their addresses are fixed, you should be able to use this in place of what I highlighted in red above as well...Originally Posted by AlphaFrog
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much. Is there a way to have the comment auto-update if I3 & I4 change without re-running the macro?
You can use event code instead of a macro. Here is the event code that will do it...
HOW TO INSTALL Event CodePlease Login or Register to view this content.
------------------------------------
If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code (this is the worksheet with the cells I3 and I4 you are using to create your comment) and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
OMG that is amazing. Thank you. I tried making a change for when the range is more than 2 cells, i.e. I3, I4, I5, & I6 and can't get it to work. How would I do that?
Programs are written for the conditions given... what works for 2 cells may not work for more cells depending on what you are doing and how many cells are involved. So...
How many cells are we talking about in total? A fixed number of cells you can give me address for? Or do you want all cells in Column I starting at Row 3?
You may also want to consider the following which I have posted in the past..
Please Note
-------------------
For future questions you may ask, please do not simplify your question for us... doing so will get you a great answer to a question you do not actually have and which you do not actually care about AND it will almost always lead to you coming back for help when the solution we give you for the simplified question cannot be applied to your actual data and its layout. One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more.
I understand that and I apologize for not being more specific. It would be a fixed 5 cells all in a column (I1, I2, I3, I4, I5), but not the entire column. But what I really need to do is to have those source cells (I1-I5) be on a different sheet and it can be called "source". Are you able to help with that? Thanks again.
It doesn't matter what the different sheet's name is... you must install the code in whatever sheet's code module which you bring up by right-clicking that specific sheet's tab and selecting "View Code" from the popup menu that appears. Here is the revised code to handle cells I1:I5 on that source sheet (combined text will be written to cell C3 on the sheet named "oem price discounted")...
Please Login or Register to view this content.
Thank you. I am sorry but I meant the the source cells (i1-I5) will be on a separate sheet (source) than the cell which I need the comment in C3 to appear. This needed C3 cell will reside in "OEM Price Discounted".
I know... the code I gave you does that. To repeat, right click the tab that contains your I1 to I5 cells, select "View Code" from the popup menu and copy paste the last code I posted into the code window that appears. Everything will work automatically after that.
Just replace below line
with thisPlease Login or Register to view this content.
Please Login or Register to view this content.
@AC PORTA VIA,
That in not necessary to do... the code is event code and, as such, must be installed in the Source worksheet code module where all unreferenced cells will automatically default to the Source worksheet since events can only take place on active worksheets (the Source worksheet will be the active worksheet when cells I1 thru I5 are changed by the user).
Last edited by Rick Rothstein; 01-29-2021 at 09:42 PM.
Thank you Rick. One last thing. I need to have multiple cells on the same sheet have their comments auto-generated from other multiple source cells. I have tried this and it is not working. Thanks in advance.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks