I'm making a program as part of a college assignment that requires my to add up the contents of an array. Now the array has 20 places, and the only method I know of atm is:a + b + c + d + e etc...They are all different numbers so I can't just do a * 20, I need a more code efficient way of adding all these numbers up, is this possible?
View 10 Replies
In VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top..The code is part of a routine to programmatically check whether an image overlaps cells that are used in a workbook. My current method of iterating over the cells in the UsedRange is slow since it requires repeatedly polling for the top / left / width / height of the cells.I'm going to go ahead an accept Doug's answer as it does indeed work faster than naive iteration. In the end, I found that a non-naive iteration works faster for my purposes of detecting controls that overlap content-filled cells. The steps are basically:
(1) Find the interesting set of rows in the used range by looking at the tops and heights of the first cell in each row (my understanding is that all the cells in the row must have the same top and height, but not left and width)
(2) Iterate over the cells in the interesting rows and perform overlap detection using only the left and right positions of the cells.[code]
Im trying to write a program that will do:
1.The average of the four numbers. This answer will be placed into a text box reserved for that value. This text box cannot be changed by the user.
2.The maximum and minimum values. These will be denoted by changing the color of the largest number green and the smallest number red.
3.The range of the numbers. The range is defined as the difference between the largest and smallest numbers. The range will be placed into its own text box, labeled as such. This text box cannot be changed by the user."
Im using visual studio 2008 and it has to be written in VB
i have one more issues, and hope is the last for now. How can I limit a textboxe's input to only numerical with certain range of values (eg -10 to 10) and with that happening while I type in the values?
View 9 RepliesWrite a program that will allow the user to be able to choose whether they want to add up a range of numbers in one of three different ways. 1) even numbers 2) odd numbers, or 3) consecutive integers. Use buttons for user choices.
Instead of limiting the user to just adding up these numbers you will also supply an Average Button that will show the average of the numbers rather than just the sum. Only the result that they have selected should be visible.
The program should look similar to the program below:
This is the program I was asked to make.
my code soo far is.....
[code....]
I couldn't figure out the formula to use for this but I assume its the same for each part of the program just with a little change.
Say I am pulling the following table, I would then like to select an ID randomly. I understand how to select a random number using a Randomize() call followed by the relevant syntax but I want to pre-define the range.
i.e. Table Data
ID | Name
4345 Mike
3456 Lee
4567 John
There will be many more names but for this example you could use 3 or 4 etc..
I was wondering how to limit the textbox to have a range of numbers like
one can input numbers from 1 to 150
I already made the textbox only do 3 characters and only numbers but kinda stuck here.
I have two user inputs (as textboxes) for two numbers I'm looking to check for all the prime numbers with the range of those two numbers and display them within a multiline textbox, however my code returns nothing but zeros, and I have seen easier ways to do it without functions but I am curious as to how to go about calculating primes within the function.[code]...
View 7 RepliesI am trying to create a form that allows users to input two numbers a high bound and a low bound then when you click the calculate button it determines all the primes within the range and displays those numbers within a multi-line text box. It seems I have everything working except how to display the prime numbers, the result from the following code displays nothing but zeros so I suspect that the range is not being saved somehow? I have asked this on other sites and people just give me completely different code or their own, can anyone help me with this specific code without changing the underlying code, I have a feeling I might be missing a variable or I am calling the function incorrectly.[code]
View 2 RepliesI have 5 columns of 11 textboxes each on my form the textboxes are generated with this code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'column 1 textboxes
[Code].....
i need a code to generate all the possible combination of the numbers a user types into the textboxes i have two images (Panel3: the textboxes where added during design time) image2: the textboex were added using the code i gave about
generate all the possible combinations of numbers typed into the textboxes (Example see panel3.jpg image),
The user will type in the desired unique numbers into the textboxes without repetition (Please see the image i did not repeat any number, so can the code detect when a number have been typed twice?) Else when running the program i will be carefull not typing two numbers twice, but its adviceable to detect when a number is typed more than once.
Then the amount of unique number the user will type or supply to the desired textboxes does not matter here and as you can see in the image the amount of numbers in each column is not the same ie it may or may not be same amount (but number must be unique. Please try and see if it can be done to prompt user to enter the amount of numbers to supply in each column)
Then After supplying the numbers just like the one in Image, The button Click will generate all the Possible Combinations of the all the numbers typed into the textboxes in the columns.. Then After generating the combinations in the Listbox, the next Button will be able to delete them from the Universal 90c5 just like the former.
I need a variable divider ex. i have numbers from my textboxes in the range of 20 to 60 i want a divider that will divide them in a range of 2 to 6 so if the number is the lowest 20 the divider will divide him with the lowest of his range number 2 if the number is 40 the divider will divide him with the number 4 if the number will be 45 the divider will divide 4,5 and so on a variable divider.
View 21 RepliesI've this very stupid litle problem. I want to populate a combobox with numbers ranging from 00 to 99. But when I ad them with a loop as an integer the first ten numbers apear only with one digit.I wonder, how can I ad a second digit to them like; 00, 01, 02... and so on without me typing the whole list?
View 2 RepliesEDIT: I am so sorry! I have added my thread to the C# discussion thread instinctively wherein in fact I have been creating my application in VB.NET so sorry! Please transfer my thread to the appropriate location! I am currently trying to mess around with a simple mp3 player and am in the process of creating a shuffle list from all the songs in my playlist.
View 2 RepliesI am using this to populate column1 combobox from a text file and it works fine.[code]I tried to add a number range using this to populate columns 4 and 5..[code]The number range populates the combobox(CB) fine but when i select a number from the CB it causes a error and selects the first item, the error loops evertime the mouse hovers over the CB..[code]
View 5 RepliesI have a datagridview named Partcotdatagridview. In this datagridview, I have two columns. The first column has a combo box with some names in the data source such as John, David, Alex. The second column is designated for amounts. Each person will have different entries in the datagrid I will select a name and enter an amount for that person. I would like to display the total for each person in 3 different labels in a different form.
View 20 Repliesok the problem is that when a button is click I want it to add 1 (+1) to a textbox. This process will keep on going on till I tell it not to...How would I just keep a running total of whats happening in the textbox...What I mean to say is that if I pressed the button 10 times, instead of it showing:111111111 I want it to automatically add the numbers up to show 10 instead.
View 1 Repliesi have the following piece of code: txtGrandTotal.Text = Val(textbox1.Text) + Val(textbox2.Text) + Val(textbox3.Text) If the numbers entered into textboxes1,2 and 3 are positive integers it all works fine, but if for example the following happens i get unexpected results textbox1 has the number 3, textbox2 has -1 and textbox3 has 6. I expect the result to be 8 (3-1=2 + 6) = 8 Instead I get 14. I understand the concept of precedent but how do I set it if I don't know if the number entered into textbox is positive or negative?
View 5 RepliesI have about 250 numbers in a list box and how can i add them all together and make it appear in MsgBox.
View 8 RepliesI have a text file (*.txt) with a name in each line, like this:
Joe
Dane
Lisa
Kelly
Now I want each name added with a number from 1 to 99.
Like this:
Joe0
Joe1
Joe2
[code]....
I have folowing code:
For n As Integer = 0 To (numbernames) - 1
strContents = objReader.ReadLine()
For i As Integer = 0 To 100 - 1
[code]....
With this code all happens ok and a new text file is created with the desired name-list with added numbers.The only problem is that the last name doesn't get a number added from 0 till 99 but for example 0 till 17.
I'm trying to add certain numbers together from a textbox full of numbers from 1 to 10. This is my
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub[code]....
When the button is clicked, it gathers the list of numbers from the test.txt file and displays it in the textbox. Now what I want to do is make a label so that after it streams the data and displays it in it's multi-line text box, is for every 10 and 1 displayed on one line, it will subtract 1 from the number in the label. For every 2,3,4,5,6 I want it to add 1. For every 7,8,9 it will not add anything.For those who can tell I'm a blackjack fan and I was curious on how to keep a running count in a label from a multi line list of numbers.
I am trying to add up numbers in a listbox.I know how to add them up and make them display on a messagebox but what I cant do is add the numbers in one listbox and then add the numbers in another listbox and subtract the total of the numbers from 2nd listbox from the total of the 1st BUT instead of displaying them on a message box how would I output those results into a label?This is the code I have for outputting the totals of a listbox onto a message box:
------------
Dim intTotal As Integer = 0 'Running
Dim intX As Integer = 0 ' Index Position
For intX = 0 To lstDebitsBalance.Items.Count - 1
[code]....
btw the name of the second listbox I want to sum up is lstCreditsBalance
how to get running total(adding numbers).
View 1 Replieshow to add together integers from the end of a list array based on certain criteria. example: a list of students assignments and grades, and im trying to add all of the grades from a certain student up based on the student id from the user.
the student table looks like this:
111 H1 09/12/2010 17
111 P1 09/14/2010 42
111 H2 10/02/2010 18
[Code].....
I have a Repeater... And it has a Weight field. the weight it displayed in a textbox. I have this piece of code:
lblTotalWeightCalc.Text += NewDV.Item(i)("Weight")
This will get the Weight and display it in my label. But when I select more than one item (which will have two weights) it will show: For Example:
Item #1 : Weight = 20
Item #2: Weight= 50
The total Weight= 2050 (it doesn't add them together) I need them to be added together....
CODE:
I have tried a million times to gt this funtion working and i cant.
I have an issue in VB6 that is giving me a major headache. When using a variable defined as a single data type, VB6 will add random numbers to the number i assign to it.
For instance I have a single variable that is manually set to 0.3. Then i create another single variable and set it to 0.25. I have the program add 0.01 to the second variable until it equals the first. But they never equal. I couldn't figure out why when both were showing they equaled 0.3.
[Code]...
I found this from a Google search and I need the VB.NET equivalent to Martin Liss' code
Dim lngIndex As Long
Dim lngTot As Long
For lngIndex = 1 To lv.ListItems.Count
lngTot = lngTot + lv.ListItems(lngIndex).SubItems(1)
Next
[Code]...
Value of type 'System.Windows.Forms.ListViewItem.ListViewSubItem' can not be converted to 'Integer'Basically, I need to total up a number column in a ListView.
In my below forms, the user select a name from the combo box list and enters an amount for the name selected. The user can enter as many entries. Every time the total button is clicked, I would like the total for each person to be display on the labels.
View 1 RepliesI neeed to create a dictionary that holds objects with a large requirement in memory. Therefore i need to make them a weak reference.I created a dictionary with an ID and a weekerence that holds my object.The annoing thins is that as soon as i finished filling up my dictionary the garbage collector has already reclaimed all of them despite there is a large quantity of RAM avaible and I did not call the gc.collect.
View 2 RepliesWhat is an easy to implement way to communicate between 2 vb.net (3.5) form applications that are running on the same machine?
The current problem is that in each program a user needs to be logged into to use. If the user is logged into one, and clicks a button to launch another, it should pass who is logged in so they do not need to log in again in the second program.
