Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Started with Excel Programming
I am planning on creating a simple program to manage the Unit Trust Funds.
I would like to have a dialog box where user can key in the name of the share, date purchased, price, unit invested etc. The program will name the sheet according to the name of the share and stored all the data into that sheet. I would like to have a second program where user can then open each sheet according to the name of the share and key in the current market value, date, etc where the data will be stored again and computation for the gain or loss will be output. As visual basic is a new programming language to me (learnt C programming), i would like to get some help on starting this program especially on getting a dialog box, getting data from the dialog box and saving them in Excel sheets. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Started with Excel Programming
It looks like you only need two steps to accomplish this task. I/O is much
simplier in VBA then C language. 1) Search in VBA window help for INPUTBOX. sub test() Answer = Inputbox("Enter Data") Activesheet.Range("A1").value = Answer 'or Worksheets("Sheet1").Range("A1").value = Answer 'or Activecell.value = Answer end sub "Bob Phillips" wrote: Get hold of a starter book, VBA for Dummies by John Walkenbach should be a good starter. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Timothy See" <Timothy wrote in message ... I am planning on creating a simple program to manage the Unit Trust Funds. I would like to have a dialog box where user can key in the name of the share, date purchased, price, unit invested etc. The program will name the sheet according to the name of the share and stored all the data into that sheet. I would like to have a second program where user can then open each sheet according to the name of the share and key in the current market value, date, etc where the data will be stored again and computation for the gain or loss will be output. As visual basic is a new programming language to me (learnt C programming), i would like to get some help on starting this program especially on getting a dialog box, getting data from the dialog box and saving them in Excel sheets. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Started with Excel Programming
Thank you for all the help given!
"Joel" wrote: It looks like you only need two steps to accomplish this task. I/O is much simplier in VBA then C language. 1) Search in VBA window help for INPUTBOX. sub test() Answer = Inputbox("Enter Data") Activesheet.Range("A1").value = Answer 'or Worksheets("Sheet1").Range("A1").value = Answer 'or Activecell.value = Answer end sub "Bob Phillips" wrote: Get hold of a starter book, VBA for Dummies by John Walkenbach should be a good starter. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Timothy See" <Timothy wrote in message ... I am planning on creating a simple program to manage the Unit Trust Funds. I would like to have a dialog box where user can key in the name of the share, date purchased, price, unit invested etc. The program will name the sheet according to the name of the share and stored all the data into that sheet. I would like to have a second program where user can then open each sheet according to the name of the share and key in the current market value, date, etc where the data will be stored again and computation for the gain or loss will be output. As visual basic is a new programming language to me (learnt C programming), i would like to get some help on starting this program especially on getting a dialog box, getting data from the dialog box and saving them in Excel sheets. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Started Tab in Excel 2007 | Setting up and Configuration of Excel | |||
Excel started, but not the file | Excel Discussion (Misc queries) | |||
Determining how excel was started | Excel Programming | |||
Can Excel be started minimized? | Setting up and Configuration of Excel | |||
Getting started programming a UDF. | Excel Programming |