Creating a form -

[BNT1 via OfficeKB.com]

Hi

would anyone steer me in the right direction please. I do not have access,
only Microsoft exel 2003

I have followed the threats on how to create a form, but will require it
modified slightly. (g).

[Gord Dibben]

Not enough information here to hazard a guess.

Please provide a few details on what type of form and slight modifications
required.

Maybe even a message ID of the threads you followed?

Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 14:50:54 GMT, "BNT1 via OfficeKB.com" <u19326@uwe>
wrote:

[BNT1 via OfficeKB.com]

Hi Gord, thanks for the response

Headings on sheet

A1 - Number
B1 - Despatch date
c1 - into comp date
d1 - Carrier
e1 - Quantity

I have so far created the form following the link below. (without the coding).
Not sure "What type of form" this is.
regards

http://contextures.com/xlUserForm01.html#Finish

Gord Dibben wrote:
>Not enough information here to hazard a guess.
>
>Please provide a few details on what type of form and slight modifications
>required.
>
>Maybe even a message ID of the threads you followed?
>
>Gord Dibben MS Excel MVP
>

>>Hi
>>
>[quoted text clipped - 3 lines]

>>I have followed the threats on how to create a form, but will require it
>>modified slightly. (g).

--
Message posted via http://www.officekb.com

[Gord Dibben]

What you found at that site is instructions for creating and using a
UserForm.

I could never aspire to providing more help than Debra has given at that
site.

Did you download either of the the sample workbooks?

Modifications will be made depending upon your requirements for different
labels and linked cells.

You may be better off simply using the built-in Data Form Excel provides.

See Debra's site for instructions and a link to John Walkenbach's Enhanced
Data Form.

http://www.contextures.on.ca/xlDataEntry01.html#List

Gord

On Tue, 24 Nov 2009 19:11:44 GMT, "BNT1 via OfficeKB.com" <u19326@uwe>
wrote:

>Hi Gord, thanks for the response

[BNT1 via OfficeKB.com]

Thanks Gord

I did download the file PartLocDB ,. It was almost what I wanted, with the
exception, that it obviously did not pick up any data already in the data
base and created a new record - thats the tweek I would be looking for. (not
that i am saying it is an easy tweek!)

Thanks again

Brian

Gord Dibben wrote:
>What you found at that site is instructions for creating and using a
>UserForm.
>
>I could never aspire to providing more help than Debra has given at that
>site.
>
>Did you download either of the the sample workbooks?
>
>Modifications will be made depending upon your requirements for different
>labels and linked cells.
>
>You may be better off simply using the built-in Data Form Excel provides.
>
>See Debra's site for instructions and a link to John Walkenbach's Enhanced
>Data Form.
>
>http://www.contextures.on.ca/xlDataEntry01.html#List
>
>Gord
>

>>Hi Gord, thanks for the response
>>

>[quoted text clipped - 26 lines]

>>>>I have followed the threats on how to create a form, but will require it
>>>>modified slightly. (g).

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200911/1

[Gord Dibben]

That's all the userform in PartLocDB does.

Appends new records to an existing database sheet or starts a new
database............in that sample workbook the PartsData sheet is hidden
and would contain your existing records.

If you want to be able have a form that allows new entries and is searchable
the built-in Data Form is what you need.

Or John W's enhanced form.

Gord

On Thu, 26 Nov 2009 14:15:45 GMT, "BNT1 via OfficeKB.com" <u19326@uwe>
wrote:

>Thanks Gord