We don't do homework, just try to help specific problems.

If you don't know how to do these things, what do you know, what are you
thinking about these questions (re solutions), and what do you need pointers
with?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"paul" wrote in message
ps.com...
I am taking an exam as part of my degree in september and i was
looking through a past paper of vba and didnt understand at all how to
answer this question??

please help


When using VBA with excel it is important to be able to read and
write to the excel spreadsheet. Write VBA commands to perform the
following tasks:

a/ Place in the variable Y the number in the cell A6 of the currently
active worksheet (4 marks)

b/ Place in the cell A7 the text "Hello world" (4 marks)

c/ Place a message box on the screen giving the message contained in
the string variable, Prompt$ and asking for a yes, no or cancel reply
(5 marks)

d/ Read the area designated by the string variable Area$ into a one
dimensional array called Input() (4 marks)

e/ Read the 5th column and 3rd row of the currently active spreadsheet
into the array element A(2,4) (4 marks)

f/ Read the value in the cell B7 from worksheet, sheet6 into the
variable, Step (4 marks)