About Us

Timothy See[_2_]

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Started Tab in Excel 2007	Bill G[_2_]	Setting up and Configuration of Excel	3	June 10th 07 08:28 PM
Excel started, but not the file	chengsun	Excel Discussion (Misc queries)	0	May 18th 06 06:20 AM
Determining how excel was started	Gilgamesh[_3_]	Excel Programming	3	September 23rd 05 01:26 PM
Can Excel be started minimized?	Bernie	Setting up and Configuration of Excel	1	August 24th 05 09:36 PM
Getting started programming a UDF.	John Herbster	Excel Programming	4	July 7th 04 05:29 PM

Menu

About Us