INDATA and OUTDATA

R

Rockbear

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
 
R

Rockbear

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

Gord Dibben

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

If Data>Form 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
 
R

Rockbear

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
 
G

Gord Dibben

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
 
D

Dave Peterson

Did you enable macros when you opened the workbook?

Did you put the code in the correct location?

What happened when you tried it?
 
Top