View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RELWOD85[_2_] RELWOD85[_2_] is offline
external usenet poster
 
Posts: 1
Default vba solutions a.s.a.p please


i have been given the following questions if anyone could
help with a solution to each i would be most greatful because i am new
to using vba in excel and im finding is all very confusing

1) produce code that allows a user to input using a input box up to but
no more than five manufactures names. to finish entry before five
manufactures names have been entered the user should input the word
QUIT. after entry is complete the number of names inputed by the user
should be displayed in a message box

2) desgin a excel spreadsheet that will allow the registration of votes
for the big listen. voters will be allowed to lodge votes for one of
five radio programmes. the form should include a cell to allow the
entry of a vote(1-5) and a button, cmdSubmit to submit this. the data
must be held in an arry. the form should also include display the
radio programm names, radio programm numbers and the current score

3)write a function to test whether an integer lies between 0 and 100.
this should return a boolean value

kind regards

relwod


--
RELWOD85
------------------------------------------------------------------------
RELWOD85's Profile: http://www.excelforum.com/member.php...o&userid=25753
View this thread: http://www.excelforum.com/showthread...hreadid=391644