![]() Set RefRange = Sh3.Range("G1:H14") '-Change as necessary. ![]() ![]() Any suggestion will be greatly appreciated. MyValue = WorksheetFunction.VLookup(Range("A2"), Range("Sheet3!G1:G14"), 2, False) Offset(RowCount, 0).Value = Me.Account.Value RowCount = Worksheets("Sheet2").Range("A1"). My code in excel macro looks something like below. I have setup the Account values in Sheet3. ![]() I am trying to do a Vlookup to search for Id of the selected Account. I dont want to expose this Id to the end users but at the same time I want the Id corresponding to the Account selected populated in sheet2. However each account will have a unique Id associated with it. I have a combobox named Account from which users will select the name of account. I have created a form in excel which takes input from users and saves the same in Sheet2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |