HELP:user-fill in form

  • Thread starter Thread starter Stift
  • Start date Start date
S

Stift

I need a excel-file with 2 tabs.

In the first tab It must be able to fill a week nr. And then som
other values.
Then that values must automattically filled in, in Tab2 in the righ
column of that week.

If you can help me, please reply !!!


Thanks in advance,

Stif
 
You weren't very specific as to if this is from one cell on sheet1 or for
all cells in a column. In any event, you can use a worksheet_change event on
a worksheet module to this sort of thing.
 
It is for all cells

When I open the file I'd like to have a sort of Popup-screen(Form?)

Where the user is asked foor weeknumber and some other values.

Then the values the user filled in,must automattically put in a tabl
with the right weeknumber :

Example:

Popup:
-------------------------------------
Give weeknumber: xxxxxx
Answer Question1: xxxxxxx
--------------------------------------

Table:
week 1 2 3 4

question1 Yes 100 No 222
question2 No 1,12 Yes 100
 
Back
Top