Set cell value by macro not a formula

[Chivers]

I want to set the value of a cell when running a macro, if the macro is not run the cell is blank and can be free format entry.

In the attached example I want to set the value of cell A1 on Sheet 1 when I run the macro. The value will be based on using the value in Cell F1 to lookup the the value in the table in sheet 2 column C where the value in Column A matches that value.

Hope that makes sense

Thanks

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

As per your requirement I covered both (i.e.) Not used Formula directly and loaded it in Macro

[sktneer]

Hi Chivers,
Welcome to the Forum.
You try this.....

Please Login or Register  to view this content.

You can change the sheet names if required.
Please find the attached sheet and click on the Green Button on Sheet1 to get the desired output in A1.

[Chivers]

Thank you SixthSense & sktneer for your quick responses, I will try them when I am back in the office tomorrow and let you know if all OK.

[Chivers]

Thanks again guys, both methods worked so I am closing the thread.

[sktneer]

You're welcome and thanks for the feedback as well.