Data entry box

[Tuff]

Hi all,

I recently found an old excel spreadsheet which contained a button which when pressed opened a data entry box.

This data entry box looks like a standard windows box. (ie look and feel was similar to say windows volume control).

The required data entry was for the key variables in the spreadsheet, and once entered into the box, data was transferred to the correct cells within the actual spreadsheet.

Now I was wondering if anyone knows how this was created?

 

[Tuff]

Sorry should be more specific.

I was wondering how the data entry box was created & linked to the actual spreadsheet?

 

[xlbo]

for the easiest way follow menu path Data>Form

your headers must be in the top row of the spreadsheet though

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question