if else statement to select values from workbook
Posted on 2013-12-28
folks I have a function which activates a select from a specific workbook
Function Select Region()
' Activating GenericUser sheet
however I would like to change the sheet to be used based on the region as specified in sheet 1 i.e.
if sheet1 b1 = europe then
else if sheet1 b1 = asia then
else if sheet1 b1 = africa then
how do i correctly program this?