Visual Basic Answers

Question#1 write vb6 program that takes n numbers as input.
It outputs the frequency of positive and negative numbers.
A sample input and output are given as follows:
Input n=9 the 9 numbers are as follows: 40& -1 59 -37 283 -91 -103 341 523
output: Frequency of positive numbers:5
& & & & & & & & & & Frequency of negative numbers:4

I have opted for the double award in college but for one of the units requires VBA programming for an excel spreadsheet - for this sheet i have written a program that will copy and past whatever is highlighted and then clicking a macro will paste the data to the sheet under the existing data without overwritting this data - i shall provide the coding i have done - the problem is that when i debug the program there is an error - the computer technicians are unable to help.



Dim ColCounter As Integer


Sub open_form_testing_one()

'

' open_form_testing_one Macro

'



'


ColCounter = 1

Selection.Copy

Sheets("Sales Report ").Select

For ColCounter = 1 To 200

If Sheets("Sales Report ").Cell(ColCounter, 1) = "" Then [error line]

Range("A" & ColCounter).Select

ActiveSheet.Paste

Application.CutCopyMode = False

Range("C21").Select

End If

Next ColCounter

End Sub


if possible please change the code and send back the correct code via email.

WHAT ARE THE USES OF A DATA BASE CONNECTIVITY

Question#1
write vb6 program that takes n numbers as input. it outputs the frequency of positive and negative numbers.a sample input and output are given as follows:
Input
n=12
the 12 numbers are as follows:
40 0 -1 59 -37 283 -91 -103 341 523
output:
Frequency of positive numbers:8
Frequency of positive numbers:4
Question#2
write a program that that reads n values in a list and prints the product of the value and the position at which it resides in the list i.e product=L[1]*,product=L[2]*2,and so on.
Note:the list does not change
Example
position: 1 2 3 4 5
value: 5 3 7 1 4
output: 5 6 21 4 20

I need a help with a Visual Basic (2008 VS Express) program for a small theater seating booking system. User needs to pull up a form to review availablae/reserved seating for 2-3 different performances. Seats are in arrays where seats closest to stage are more expensive. Nothing fancy and seats can be a table type view. User can purchase/reserve seat, purchase season ticket/seat, and cancel seats. The seating chart will save to a file so the theater Owner can see total seat sales and seating chart for each performance . Can you help? Thank you!)

Change this into vb code
function update(class,train) {
'OUTPUT: changes to the globals.
' INPUT: a "train"ing example
' containing attribute/
' value pairs in some
' "class"

I++ ' update number of instances
if (++N[class]==1) ' update counts for each class
then C++
fi()
for <attr,value> in train
do if (value != "?")

Give me an example to remove stopword.
In a sentence there are many unrelated word such as the stop words,so i need to remove it thus i can only get the main point.
How to filter it?And how to make the system read a whole sentence then break it into strings.I know i need to do some array to read the list of stopword,but then how to make the system read the sentence word by word ?

I would like to ask a question regarding google interactive chart API. How do I get the data from my own database in order to show my chart in stead of hard coding it in visual basic?