Hi, could someone help me with this please, I am ok with excel but new to vba and my problem is this:
I have a userform with just a few textboxes and it is the first one I am having trouble with, I would have done it ages ago in excel but anyway, the userform is on a sheet called "start" and the textbox is called "player_name" and the place it is, is on a sheet called "data" and the range is A23:A107.
I am wanting to use Vlookup to see if he is aready in so as to add his stats, and if he isn't then add his name to the bottom of the range and add the new stats.
It is only that bit I cant do, I have been trying If(Vlookp in all combinations but to no avail, I bought the dummies guide and used google so you are my last hope.
The stats are on the userform but I should be able to do them if I (you) can sort this out please.
Thanks in advance.
Len
I have a userform with just a few textboxes and it is the first one I am having trouble with, I would have done it ages ago in excel but anyway, the userform is on a sheet called "start" and the textbox is called "player_name" and the place it is, is on a sheet called "data" and the range is A23:A107.
I am wanting to use Vlookup to see if he is aready in so as to add his stats, and if he isn't then add his name to the bottom of the range and add the new stats.
It is only that bit I cant do, I have been trying If(Vlookp in all combinations but to no avail, I bought the dummies guide and used google so you are my last hope.
The stats are on the userform but I should be able to do them if I (you) can sort this out please.
Thanks in advance.
Len
