Hi,
I have built a userform in which users can input, recall and amend sales data which is stored in an underlying spreadsheet. I've hidden/procted the sheets that the data is written to so that users cannot amend data wihtout using the form and the inbuilt controls to ensure correct data input.
However I want to show the users stats based on the data they have input. I have designed this in a spreadsheet but can't get it to show on the userform.
How do you either (a) link a userform SS to a specified range on the underlying ss? (b) do anything similar to acheive the same effect?!?! I would prefer it to remain in ss format (as opposed to .gif etc) so that I can maintain the formatting (e.g. collapsable outlines etc).
Thanks very much for any help offered!!
Arthur =D
I have built a userform in which users can input, recall and amend sales data which is stored in an underlying spreadsheet. I've hidden/procted the sheets that the data is written to so that users cannot amend data wihtout using the form and the inbuilt controls to ensure correct data input.
However I want to show the users stats based on the data they have input. I have designed this in a spreadsheet but can't get it to show on the userform.
How do you either (a) link a userform SS to a specified range on the underlying ss? (b) do anything similar to acheive the same effect?!?! I would prefer it to remain in ss format (as opposed to .gif etc) so that I can maintain the formatting (e.g. collapsable outlines etc).
Thanks very much for any help offered!!
Arthur =D