How do i assign “ActiveCell.FormulaR1C1” to read a cell value instead typing it?

0


I am writing a code to display the properties of a Honda car when a macro button is pressed. However, i could only type fixed Strings like "Honda", "Motorized seats" etc. into the code which is not very flexible.

I wish to replace "Honda" with the cell value so when i change the value of cell in my worksheet, the code will read the updated cell value and process accordingly.

Please Login or Register  to view this content.

Any help or suggestions to improve would be great. Thanks!

Like this?
Avoid using select, it is rarely needed and slows down your code.

Please Login or Register  to view this content.

It is always a good idea to post a small example.

Thank you for the prompt reply! I am trying to do a simple interface where a user can select 2 or more car brands. The program will then compare the selected car's properties and display it here.

CarProj.xlsm

What i require now is for the program to automatically read the values from another worksheet instead of me just plain typing their properties into the code. (e.g "Honda", "Motorized seats"). I wonder if that is possible?

Here is the full code :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Your attachment failed, try to post a new example, you can use the insert image button to insert any file, also an excel file.

Please use code tags ( the # button) instead of html tags
HTML tags do not permit scrolling and make posts hard to read
Thanks

I forgot, welcome on excelforum
Why did you use toggle buttons?

Something like this?
CarProj.xlsm

Do you mean that you want the car properties of the car that has the highest speed?

Originally Posted by dotchiejack

Something like this?
Attachment 660335

For the benefit of all, please share the code used in your post as well as attaching a workbook. Thanks.