VBA macro problem regarding folder generating

Hi,

I am trying to make an excel sheet with a macro. The goal would be if I click on a cell and then on a button (with a macro assigned to it) it would create a folder to a specific place with the name of the cell.

However I would it like this: if I click on the Rng(r,c) cell, it should create the folder with a name of this cell value and to a place which is in the (r, c=c-3) cell. But unfortunately I couldn't find out how to refer to a columns value next to another column by 3 columns.

Example:
D1 cell: file://\\network_folder\subfolder\
D4 cell: 45678

So if there is 45678 in D4 cell, then after starting the macro it would create a folder named 45678 to the place of D1 so I can find my new folder: \\network_folder\subfolder\45678

Here is the macro, I highlighted the part which is wrong now, and maybe i shouldn't use Range function?

Please Login or Register  to view this content.

Thank you in advance very much!

Regards,
István

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

i don't know why all the loops but i would do it this way:

Please Login or Register  to view this content.

You can paste the code on the VB editor (Alt+F11) after double clicking the SheetName (alternatively you can right click and select View Code)

Please Login or Register  to view this content.

Not in a module, not in the original Sub. The code is executed each time you change the selection so it is an event triggered code. Worksheet SelectionChange procedure is installed with the worksheet, ie. it must be placed in the code module of the appropriate Sheet object. To create a worksheet SelectionChange event: use the Visual Basic Editor -> in the Project Explorer, double click on the appropriate sheet (under 'Microsoft Excel Objects' which is under the VBAProject/name of your workbook) -> in the Code window paste the provided code.