INDATA and OUTDATA

  • Thread starter Thread starter Rockbear
  • Start date Start date
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
 
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
 
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
 
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
 
Did you enable macros when you opened the workbook?

Did you put the code in the correct location?

What happened when you tried it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top