Set range problem

Hi,

In the uploaded file I would like to run the code in different sheet, right now if you type user in sheet3 it will return as name, I would like to run it in sheet1 and only in selected cells (A1:A20, A22:A25, B1:B20, B22:B25). Can someone amend the code.

Thanks

Hi Hawkeye16, can I ask for a check that if a username is not on the list then MsgBox?

Thanks

I got the message but it let me enter the value, would it be possible to clear the cell if username is not on the list?

Thanks

Can you use inputbox instead? ChangeEvents is conflicting with my other macros.

Thanks

If you use turn of enableevents, it shouldn't interfer.

Try this (in the Sheet1 module) and see attached:

Please Login or Register  to view this content.

Hope it helps!

Cheers,
berlan

Hi berlan,

Thanks for the response, I made some changes to my file so it affect this code too, sorry about this but I would like this to be a Sub routine insted of ChangeEvent, I uploaded a sample file and this sub routine will be called in cells B6 to B8.

Thanks

Just an update:

Some of the problems are solved on this thread;
http://www.excelforum.com/excel-prog...d-nothing.html