HI, NEED A LITTLE/MUCH HELP

Have excel sheet that I want to put data into, but true dialog boxes..

excample of data
A1 B1 C1 D1
art.number Art.name Location How many
100001 Erasers B-0613 200
100001 Pencils A-1302 2000

How do i make a dialog box to put in the data, AND a dialog box for erasing
the data, when I use the same dialog box to take articles out

Buttons when I start the sheet can be

INPUT DATA

and when I want them removed

OUTPUT DATA



--
Just a regular user, with function skills, nor programming what so ever, but
good with IF...COUNTIF and other functions, and tried some macroes... BE
gentle, hehe

Rock

Simple way, menus :

Data -- form

other way(s) will require coding

"Rockbear" wrote:

HI, NEED A LITTLE/MUCH HELP

Have excel sheet that I want to put data into, but true dialog boxes..

excample of data
A1 B1 C1 D1
art.number Art.name Location How many
100001 Erasers B-0613 200
100001 Pencils A-1302 2000

How do i make a dialog box to put in the data, AND a dialog box for erasing
the data, when I use the same dialog box to take articles out

Buttons when I start the sheet can be

INPUT DATA

and when I want them removed

OUTPUT DATA



--
Just a regular user, with function skills, nor programming what so ever, but
good with IF...COUNTIF and other functions, and tried some macroes... BE
gentle, hehe

Rock

Well THAT i know, that coding are nessasary, but would be helpfull to know
some code. :)
--
Just a regular user


"nathan_savidge" wrote:

Simple way, menus :

Data -- form

other way(s) will require coding

"Rockbear" wrote:

HI, NEED A LITTLE/MUCH HELP

Have excel sheet that I want to put data into, but true dialog boxes..

excample of data
A1 B1 C1 D1
art.number Art.name Location How many
100001 Erasers B-0613 200
100001 Pencils A-1302 2000

How do i make a dialog box to put in the data, AND a dialog box for erasing
the data, when I use the same dialog box to take articles out

Buttons when I start the sheet can be

INPUT DATA

and when I want them removed

OUTPUT DATA



--
Just a regular user, with function skills, nor programming what so ever, but
good with IF...COUNTIF and other functions, and tried some macroes... BE
gentle, hehe

Rock

What nathan meant was, you don't need code if you use the built-in DataForm to
create and delete entries.

If DataForm is not sufficient, then you would need code.

"Put them in" and "take them out" is too generic to help with tailoring code.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 02:26:01 -0700, Rockbear
wrote:

Well THAT i know, that coding are nessasary, but would be helpfull to know
some code. :)

Ok :) have looked at it and have to agree thet it has all I need. Is there
some way to make it start when I open the sheet ?

A million thanks for the help guys
--
Just a regular user


"Gord Dibben" wrote:

What nathan meant was, you don't need code if you use the built-in DataForm to
create and delete entries.

If DataForm is not sufficient, then you would need code.

"Put them in" and "take them out" is too generic to help with tailoring code.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 02:26:01 -0700, Rockbear
wrote:

Well THAT i know, that coding are nessasary, but would be helpfull to know
some code. :)

Assuming that "open the sheet" means activate that particular worksheet in the
workbook.

Right-click on the sheet tab and "View Code". Copy/paste the code below into
that sheet module.

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Alt + q to return to the Excel window.

An alternate would be this code in the Thisworkbook Module.

Right-click on the Excel Icon left of "File" on the Menu and "View Code".
Copy/paste the code below into that module.

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
ActiveSheet.ShowDataForm
End Sub

Runs when the workbook is opened.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 09:15:01 -0700, Rockbear
wrote:

Ok :) have looked at it and have to agree thet it has all I need. Is there
some way to make it start when I open the sheet ?

A million thanks for the help guys

Hi :)
I tried bioth versions, no one worked
--
Just a regular user


"Gord Dibben" wrote:

Assuming that "open the sheet" means activate that particular worksheet in the
workbook.

Right-click on the sheet tab and "View Code". Copy/paste the code below into
that sheet module.

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Alt + q to return to the Excel window.

An alternate would be this code in the Thisworkbook Module.

Right-click on the Excel Icon left of "File" on the Menu and "View Code".
Copy/paste the code below into that module.

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
ActiveSheet.ShowDataForm
End Sub

Runs when the workbook is opened.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 09:15:01 -0700, Rockbear
wrote:

Ok :) have looked at it and have to agree thet it has all I need. Is there
some way to make it start when I open the sheet ?

A million thanks for the help guys

Did you enable macros when you opened the workbook?

Did you put the code in the correct location?

What happened when you tried it?

Rockbear wrote:

Hi :)
I tried bioth versions, no one worked
--
Just a regular user

"Gord Dibben" wrote:

Assuming that "open the sheet" means activate that particular worksheet in the
workbook.

Right-click on the sheet tab and "View Code". Copy/paste the code below into
that sheet module.

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Alt + q to return to the Excel window.

An alternate would be this code in the Thisworkbook Module.

Right-click on the Excel Icon left of "File" on the Menu and "View Code".
Copy/paste the code below into that module.

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
ActiveSheet.ShowDataForm
End Sub

Runs when the workbook is opened.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 09:15:01 -0700, Rockbear
wrote:

Ok :) have looked at it and have to agree thet it has all I need. Is there
some way to make it start when I open the sheet ?

A million thanks for the help guys



--

Dave Peterson