Hi,
I have created a userform to add in the current weeks exchange rate.
I now cannot get the code to work once clicked OK to find the week number in a list on a worksheet "Fx" and add the values from the userform to the page.
I have attached pictures of the userform and the worksheet I am trying to add into - hopefully it makes more sense to what code I am needing.
I am very new to VBA and do not fully understand so any help would be greatly appreciated.
Userform.PNG
Worksheet.PNG
Bookmarks