Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Achive and read Database
I will appreciate your helping in this matter.
I am in process of learning VBA in Excel. I wonder if somebody can help me to achieve a sample of archive and read database program. Basically, I want to know if I can typed information in the sheet1 then click a macro to write it in the sheet2. Then I would like to click the macro read data and through the pull box choose the data I want to read and located in its respectively cells in the sheet1 (see below) Thank you very much in advance. Giovanna Fron sheet1 Name Giovanna Test # 300 Track # 5000 Date 8/30/2005 Weigths Lengths 10 100 20 200 From Sheet2 Name Test # Track # Date W1 W2 L1 L2 Giovanna 300 5000 8/29/2005 10 20 100 200 Carlos 301 4000 8/30/2005 5 7 95 205 Jose 302 3500 8/31/2005 2 4 90 100 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Achive and read Database
Since you are new to VBA, I Guess you are mixing up some things. Excel isn't a database but a spreadsheet. Access uses a database if I read you''re want to transport data from sheet 1 to sheet 2 I assume you meas listbox or combobox with "pull box" I assume you want to use a form to do it. actually it's not a thing someone will write in 5 to 10 minutes so some pointers. insert a form in the VBA IDE (ALT-F11) place your buttons and combo/listbox write your proccessing code in the form to open your form use code like this: Code: -------------------- Sub test() UserForm1.Show End Sub -------------------- Give the controls (buttons,boxes and so on) logical names before you start coding like: Cmd_ArchiveToSheet2 and Cmd_RetrieveFromSheet2 It will make you type more but it will keep your code readeble. Important one put _option_explicit__ on the top of your code modules to forc you to declare all of your variable. -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=399775 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Achive and read Database
Dnereb;
Thank you for your advise.... Unfortunately my VBA knowledge is so low that I could not understand very well you message. I did the buttons but I do not what to do next... I will appreciate your helping me!!!!!! Regards. Giovanna "Dnereb" wrote: Since you are new to VBA, I Guess you are mixing up some things. Excel isn't a database but a spreadsheet. Access uses a database if I read you''re want to transport data from sheet 1 to sheet 2 I assume you meas listbox or combobox with "pull box" I assume you want to use a form to do it. actually it's not a thing someone will write in 5 to 10 minutes so some pointers. insert a form in the VBA IDE (ALT-F11) place your buttons and combo/listbox write your proccessing code in the form to open your form use code like this: Code: -------------------- Sub test() UserForm1.Show End Sub -------------------- Give the controls (buttons,boxes and so on) logical names before you start coding like: Cmd_ArchiveToSheet2 and Cmd_RetrieveFromSheet2 It will make you type more but it will keep your code readeble. Important one put _option_explicit__ on the top of your code modules to forc you to declare all of your variable. -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=399775 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for an Easy way to Achive a Result | New Users to Excel | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
how do we achive the default view settings? | Excel Programming | |||
How to read from a SQL Server table into Excel and use the Excel cell format as in the database | Excel Programming | |||
how to read excel spreadsheet into database (DB2) | Excel Programming |