I wonder how I can subtract cells in VBA? I want to use an For-loop that subtract column "B" with column "C". I want it to take all the values in kolumn "B" minus ( - ) all values in column "C" in the whole range.
View 12 RepliesMy main goal is to have an excel spreadsheet that automatically plots the overall success of my stock portfolio over time (% change over time). I've been able to incorporate stock data into my spreadsheet by linking it to the web, but the trouble is the spreadsheet will keep no history of what the previous stock values were, so I can't graph how things change over time. This sounds like it might be too complicated to be built in to excel, so I was wondering if anyone knew how to program this in Visual Basic. Maybe something like this.... If refresh then new cell plus new time stamp. Another possibility would be to have a whole bunch of cells that refresh only once but at longer and longer intervals, e.g.,
[Code]...
I have a DataTable and want to connect the cells of one of its columns to cells in some other DataTables.
For example:
DataTable1.Rows(0).Item(2) is connected to DataTable2.Rows(4).Item(6)
DataTable1.Rows(1).Item(2) is connected to DataTable4.Rows(2).Item(3)
DataTable1.Rows(2).Item(2) is connected to DataTable3.Rows(11).Item(4)
...
How can I do this?
I'm doing this program in Visual Basic and its supposed to calculate the GPA by entering the completed courses in a listbox. Its does calculate the GPA as its supposed to by adding the values using a "Add to list" button, but i have to also update the value of the GPA if a remove an item from the listbox using a "Remove from List" button. Is there a way a remove the line and also make the subtraction work.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddtoList.Click
'This is the Add button
course = txtCourseName.Text
[code]....
As part of a school assignment I have to design a program that allows people to add items to there backpacks but only upto a certain limit depending on age height etc. I completed the code to work out each packs maximum weight and thought I had almost finished but... Now I am trying to use a list box to add up the total weight of items added to each pack (below) but rather than add up I am just assigning the value 5 to the pack1weight.
Code:
Dim pack1weight As Integer
Dim tentW As Single
Dim maxweight1 As Single
[code]....
Im new to vb.net but learnt quiet abit, im using a book and getting to the stage where it gets confusing, anybody know of any videos or a better way to learn? first of all I have connected to a database but i want to beable to get the servername, username and password from a registry file instead of putting it directly into the code,
Also in the database I can add and update records etc... how would I make it take the current value in the table and add / subtract to it then update? eg. in the table i have 60, i want to add 10 to the value so 60 + 10 = 70 update record with 70. etc.
I would like to subtract a month using vb6.. Which function to use??
View 3 RepliesI'm stuck on writing a query to subtract "Amount to pay" with "amount paid", my assignment sheet says to 'use two queries and subtract in vb'. but i still don't really understand it
What the program is supposed to do is:
1. the user types in a specific customer id
2. the button "What is owed by the Customer ID?" runs the query
3. the query returns and opens a HTML with the customer id, the amount to pay, the amount paid and the total amount.so far what i've come up with is:
sSql = "SELECT CustID, SUM(AmountToPay) As AmountOwing, SUM(AmountPaid) As PaidOff FROM Order, Payment WHERE Order.CustID = Payment.CustID AND CustID = " & sSearchValueA & "GROUP BY CustID;"
I have 15 ofTextBoxs.1 to 5 is TextBoxs have a fix value and 6 to 10 is TextBoxs where the user
can input some value ,finally the textboxs 11 to 15 as a result What i want to do is when user input the value in textboxes(6) then the result automatically raise in textboxes(11).Then when put value in textboxes(7) then result automatically in textboxes(12) and also..
[Code]...
I'm looking to design a calculator that adds and subtracts binary numbers. I'm new to this program and stumbling on where to start?
View 6 RepliesCan someone show me an example of how to add or subtract when you have the button value going into the textbox like this[code]...
View 4 RepliesI have built a small VB.NET Calculator but whenever I add, subtract or multiply by 0 the answer is always 0. Here is my code:
Spoiler
Option Explicit On
Public Class Calculator2
[Code]....
In excel macro i got this two variables:
TimeF_1h = Cells(x, 3) - 0.041667
TimeF_12h = Cells(x, 3) - 0.5
i tried to do the same in Vb.net, but something is wrong i assume i should do it other way.
TimeF_1h = .Cells(x, 3).Value - 0.041667
TimeF_12h = .Cells(x, 3).Value - 0.5
I don't know what does it mean:
0.041667 and 0.5
in excel column are dates in this format:
2011-03-07 16:35:23
can i do this in VB.NEt example i wanna subtract the difference from 8:00 AM TO 12:00 pm how can i do this what namespace do i need? how can i add time? how can i add two dates
View 3 Repliesin one textbox i have 10:00 PM and in another textbox i have 12:00 PM....i want to subtract 10:00 PM from 12:00 PM and get result ie 2 hours...how can i perform that?
DateTime.TryParse(TextBox1.Text, d1)
DateTime.TryParse(TextBox2.Text, d2)
I'm Currently working with a payroll system with daily time record.. I'm having troubles with their time records, what i did is this, i created 6 textboxes on the form the 1st textbox is for the AM IN 2nd is for the Lunch OUT the 3rd Is for the total hours worked for the half day, and the same for the 4th to 6th textboxes. I actually get the difference of 2nd and 1st textboxes and show the result at 3rd textbox and same for the 4th-6th textboxes using this code that I also get in this site
Dim TimeA As Date
Dim TimeB As Date
Dim hh As Integer
[Code].....
but i really didn't understand it so right now I don't know how to add the value of textbox3 and textbox6 so I could get the total hours worked of the employee..
I'm writing a program that checks something once a day. When the property has been checked, I store the "Now" value as LastCheckedDate. Since this is a dateandtime, in includes both the value of the date and the value of the time. The next time the program is run, I want to determine if the current value of Now has a different date than the LastCheckedDate. The problem is that functions like Datedif subtract the two values using the times, so if the first check was at 16:30 on 11/2/2011 and the second check was at 9:05 on 11/3/2011, the result is about 16 hours, which is 0 days.
[Code]....
I have two datetimepicker controls one as a start date the other as end date, How do I go about subtracting the values to ge the number of hours? I tried...
[Code]...
I have some problem with my project.
1) I want to convert String (ex : "14/03/1987",...) to system datetime
2) I want this function : Subtract(date1,date2)
==> result: if subtract(date1, date2) > "1 month" then ......do something else if .........do something
I have some problem with my project.1) I want to convert String (ex : "14/03/1987",...) to system datetime2) I want this function : Subtract(date1,date2) ==> result: if subtract(date1, date2) > "1 month" then ......do something else if .........do something
View 5 RepliesMy question title says all. Suppose the given date is 7th july 2011. So what I want to get in result is 6th July 2011. And leap years aren't to be counted. The day number always should be one less than today. I did this:Dim year As Date = "1/15/2009"''adds 1 years to current dateMessageBox.Show(year.AddYears(1))
View 5 RepliesI'm completely new to programming and wondered if you could help me. I've designed a simple calculator that can add numbers together but am now trying to create a subtraction button. This seems more complicated, I've searched various forums but am a little confused and wondered if any of you can help or point me in the right direction. Here is the coding I've done for the Add button (cmdPlus):
Private Sub cmdPlus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPlus.Click
[Code]...
How do I subtract a month from a date object in VB.NET?
View 4 Repliesif the subtracted date is a saturday or sunday then subtract more days, before adding to arraylist..when i do this, the date stays the same and doesnt subtract, i get a conversion string to double error.[code]
View 2 Repliesi have a problem regarding datagrid.remove and textbox. This is a Function to Add and Subtract Values on a specific Column. If I cellclick on the main datagrid on a specfic row which has record where the record goes to the other datagrid with no record yet to be filled with record, the textbox will count/ add all the values from the UNITS COLUMN and in an instance on one row removed in the other datagrid, the total value of units in the textbox does not subtract or less. here's the code.
Public Function total_units_remove() As Double
Dim totalunits As Double = 0
Dim i As Integer = 0
[Code].....
I have a bound datagridview that contains a column that stores how many hours an employee has worked in a day. That column gets summed up using an expression and then displayed in a label. I have another column that contains checkboxes. When the user checks a checkbox, the hours in that row should be subtracted from the total in the label. How can I accomplish this?
View 3 RepliesI have a 3 column listview. Column 1 and 2 has few integer. How can I subtract Column 1 and column and show the result in column 3. Below is a sample data for columns.
View 5 RepliesWould it be possible to convert strings to ASCII and subtract a number from each at the source, then add a number at the receiving end? I am sending messages on a LAN network (hopefully) and I know the packets may be monitored so I want to make sure they at least can't be read just by opening the data, something simple will do.
View 3 RepliesIm creating a registration application where i have a listbox that displays a Course Name column and a Credit Hours column. I also have a textbox that keeps a running total of the credit hours of each course added to the list. When i remove a specific item from the list, i also want to subtract the number of the selected item from the running total in the text box. Essentially i just want to subtract a certain part of a list item from a variable i have.
View 1 Repliesin one textbox i have 10:00 PM and in another textbox i have 12:00 PM....i want to subtract 10:00 PM from 12:00 PM and get result ie 2 hours...how can i perform that?
DateTime.TryParse(TextBox1.Text, d1)
DateTime.TryParse(TextBox2.Text, d2)
the code is to convert the text into time.
[code].....