Search : in
By :

Enter data using a userform

Last answer on Jun 17, 2009 5:21:34 pm BST SoStuck, on Jun 5, 2009 4:13:28 am BST 
 Report this message to moderators

Hello,

My problem is i am trying to make a spreadsheet where data is entered using a userform. I am using 2 text boxes and 2 comboboxes, 2 buttons to add and one to close. I want it to be able on opening to find the first blank cell in column A, select it and insert the data in it and the respective cells to the right, save the data and be ready to insert more data on the next row until the user closes the userform. If anyone can suggest how to do this I would greatly appreciate their help or advice.

Configuration: Windows XP
Firefox 3.0.10

Best answers for « Enter data using a userform » in :
Disk boot failure - Insert system disk and press Enter ShowDisk boot failure - Insert system disk and press Enter A new hard drive was installed The hard drive is unplugged Corrupted system files Damaged disk If it happens that you are prompted by the following error message "DISK BOOT...
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Download Advanced TCP IP Data Logger ShowDescription: Advanced TCP/IP Data Logger will help you in your daily technical needs. You will be able to get information about your network and any device that is connected to it in real time. Features: You can send and receive serial data...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...

1

 Progrower, on Jun 17, 2009 5:21:34 pm BST

Check this site out http://www.contextures.com/xlUserForm01.html Has a good basic Form

Reply to Progrower