vba command
 

can anyone help me write vba commands for these below

amy help would be grateful

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"
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

d/ Read the area designated by the string variable Area$ into a one
dimensional array called Input()
e/ Read the 5th column and 3rd row of the currently active spreadsheet
into the array element A(2,4)

f/ Read the value in the cell B7 from worksheet, sheet6 into the
variable, Step

vba command
 

I can help answer homework problem b

"paul" wrote:


can anyone help me write vba commands for these below

amy help would be grateful

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"
Range(Cells(1, 7), Cells(1, 7)) = Chr(72) + Chr(101) + Chr(108) + Chr(108) +
Chr(111) + Chr(32) + Chr(87) + Chr(111) + Chr(114) + Chr(108) + Chr(100)

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

d/ Read the area designated by the string variable Area$ into a one
dimensional array called Input()
e/ Read the 5th column and 3rd row of the currently active spreadsheet
into the array element A(2,4)

f/ Read the value in the cell B7 from worksheet, sheet6 into the
variable, Step

vba command
 

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"paul" wrote in message
ups.com...

can anyone help me write vba commands for these below

amy help would be grateful

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"
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

d/ Read the area designated by the string variable Area$ into a one
dimensional array called Input()
e/ Read the 5th column and 3rd row of the currently active spreadsheet
into the array element A(2,4)

f/ Read the value in the cell B7 from worksheet, sheet6 into the
variable, Step