Input data in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello guys,

we are going to input data very frequently, and we need an easier way to
input it.

I remembered i came up to an excel file were it had:
'Input Data' i clicked on it, and then a pop up window came up (like the
ones in Access) and had 4 separate tabs to enter data. Is there a way to
create such a pop-up window ?

thanks guys....
 
It sounds like the file you came across had a userform started by a button
on the sheet.

The short answer yes, it can be done.

In Excel, right-click on a tab name and click View Code to open the VBA
editor. Open the VBA help file and look at UserForm, TextBox, ListBox,
ComboBox for starters.

Ian
 
Back
Top