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