Input data in excel
 

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....

Input data in excel
 

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

"Haris" wrote in message
...
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....

Input data in excel
 

thanks...
its userform i meant. I will try and see if it is possible to understand it.


"Ian" wrote:

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

"Haris" wrote in message
...
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....

Input data in excel
 

Hello Haris
See also: ActiveSheet.ShowDataForm

Cordially
Pascal

"Haris" a écrit dans le message de news:
...
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....