popup boxes/user input

[papermoon]

if i wanted to introduce pop-up boxes instead of just taking user input from cells, is that possible?

[dominicb]

Good evening papermoon

if i wanted to introduce pop-up boxes instead of just taking user input from cells, is that possible?

Yes, they're called userforms. Have a look at the attached example.

HTH

DominicB

[papermoon]

Thanks alot. I did some more reading up on them and I think I know how to use them now. I just have one question. How do I set it so that the user input in the form links with a cell in the spreadsheet? do i just put [name of form text box].value=cell(x,y).value?

[papermoon]

bump (10char)

[papermoon]

anyone? (10char)

[papermoon]

and how did you get a button on the excel sheet itself to load the popup box?

[dominicb]

Hi papermoon

Patience with your bumping my friend. Also, you know if you write too much on this forum your head will explode.

Actually, it won't but to help you more effectively, we need a bit more info. Your question is way too general, and I've no idea of your skill level, but ...

Load up my sample file and press Alt + F11. This will open up the VBE and expose the code that drives the form. Your earlier assumption on the link between form and cell is correct - remember your in coding territory now, so you have to do more stuff manually. There are no automatic links.

The button is an object from the Control Toolbox toolbar and the code is in the Sheet1 module within the VBE. The magic line is :

Please Login or Register  to view this content.

You can also create a button (more easily) using the Forms toolbar, and attaching a macro.

HTH

DominicB

[papermoon]

thank you

how do i get a variable with a stored integer to be able to specify a range/criteria? for example, for this code:

Please Login or Register  to view this content.

how would I get the criteria1 or criteria2 to be a variable? do i just put the variable name where the 2000 or 3500 number is?

[dominicb]

Hi papermoon

Next time you have an unrelated question, please start a new thread.

Please Login or Register  to view this content.

HTH

DominicB