Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel functions

0

I am having some values in comments to corresponding cell i.e in cell A1 there is a value, like 20, in corresponding cell A1.  comments i am having another value like 10 

So I have to link it for calculation example 20*10=200

I am having large data with 10k 

With functions how can I do

Please reply sir

Answer
Discuss

Answers

0

To the best of my knowledge there is no worksheet function which can access cell comments. Consider moving the values in the comments to a hidden column.

With 10K rows, moving the values should better be done using VBA. So, if VBA can access the comment, why not user a UDF (User Defined Function) to do the calculations without having a hidden column?

First off, yes, that could be done. However considering the effort required to maintain data in comments, further, considering the errors that must occur using such a complicated system for data entry and maintenance over 10K rows (!) I would very quickly forget about the idea. In Excel, data belong into cells.

Perhaps you can explain why some one thought using comments for such data a smart idea in the first place. Perhaps a link could be established between a hidden column and a comment. My drift is to use VBA to create a comment based upon an entry in a column which is then hidden. The user would see the comment but the system would use the value in the hidden column for calculations. That sounds very complicated, and it is. Perhaps, if you explain your reasons, a better way can be found.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login