VBA script won't run

[TomM]

I am trying without success to get a basic VBA script to run (I copied/pasted it from http://www.mrexcel.com/forum/showthread.php?t=1321).

I saved code to a new module under the current workbook in the VBA Project pane, and then saved workbook as a .xlsm file. I can't get script to run, namely, it has no effect. Am I missing something obvious here?

Thanks

 

[hiker95]

TomM,

The link you posted is for the Worksheet_SelectionChange Event.

This code does not go into a Module.


Follow the below instructions.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Select the worksheet in which your code is to run
3. Right click on the sheet tab and choose View Code, to open the Visual Basic Editor
4. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
5. Press the keys ALT + Q to exit the Editor, and return to Excel


Then make a single selection to a cell in that worksheets column A.


How about explaining what you are actually trying to do?

 

[TomM]

hiker95-

That works just great. FYI, I can make a selection change anywhere in the worksheet -- not just column A -- to activate this subroutine.

Why I am trying to do this:
I have a form which gets populated via VLOOKUP functions from another worksheet; cells are set to wrap and are not merged. I need cells in the form to autofit the row height since number of lines of text can change. However, they won't autofit when populated via a lookup -- I have to toggle the AutoFit command, or click on the row border. Note that autofit works as expected when I copy and paste the actual values.

Thanks much.

 

[hiker95]

TomM,

Thanks for the feedback.

You are very welcome. Glad I could help.