VBA Macro to Input Data in a cell

[akynyemi]

Hi,

Assistance required.

I have a very simple formula to locate Cell Address "=ADDRESS(1,MATCH($A$3,$3:$3,0),3)" a combination of two functions, Address and Match.

I want to write a VBA code in such a way that the Row number (1 in formula above) would be from an input box, while the rest of the formula would be constant as above. A second input from an input box would then be pasted on the resulting cell address gotten from formula above.

Thanks.

[HSV]

Something like this?

Please Login or Register  to view this content.

[akynyemi]

Hi Harry,

Thanks so much for the code. I was able to put in my values in the code you provided but had an issue after putting in the second value to be displayed in the cell. I get the error message "Error Range of Message Global Failed"

Please see code below.

Please Login or Register  to view this content.

[HSV]

Hello akynyemi,

Could you upload your file by what you are doing?
Thanks.

[akynyemi]

Hi Harry,

Please find attached.

Thanks and Regards.

[HSV]

Will this work for you.

Please Login or Register  to view this content.

[akynyemi]

Hi Harry,

It worked perfectly. For me you have made the impossible possible.

Thanks.

[HSV]

You're welcome akynyemi.
Thank you for the rep.

[akynyemi]

Hi Harry,

I did post a thread a few days ago and have not received any response till now. Do you have any idea about this vba issue I have below.

VBA Code to Request a Password When Path (File Location) of Excel File Changes

I want a VBA Code to password an excel file in a way that a password/New Password would be required/requested to open the file if the present path of the file is changed to another path. e.g. Password/New Password would be requested if C:\Users\Frank\Desktop\Excel.xlsx Changes to C:\Users\Mark\Desktop\Excel.xlsx or put more lightly, excel file to request password to open if the file is copied from one location to the other or from one computer to the other.

Thanks a million.

[HSV]

I can always take a look to that thread.

[jeffreybrown]

@akynyemi,

Moderators Note:

• Please follow Forum Rule #3 and use code tags.
• Added this time in post #3, but please use them in the future…Thanks.