JoannDavies
MIS
I'm doing a User Form in Excel and I want to link one of the text boxes to data in a particular field in my spreadsheet.
This works just fine when I type, for example, "b4" in the ControlSource Property. It links up just fine and shows the data from cell b4 in Sheet1....
However, how the heck do I do it if I want to link it to cell b4 in Sheet2?? I keep trying different ways of telling it to look at Sheet2 but I can't seem to get it quite right...
Can anybody shed some light on this? It's probably soooo simple and I just can't see it.....Thank you!!!
This works just fine when I type, for example, "b4" in the ControlSource Property. It links up just fine and shows the data from cell b4 in Sheet1....
However, how the heck do I do it if I want to link it to cell b4 in Sheet2?? I keep trying different ways of telling it to look at Sheet2 but I can't seem to get it quite right...
Can anybody shed some light on this? It's probably soooo simple and I just can't see it.....Thank you!!!
