I want to auto fill a range like this:
In Sheet1!A1 i have the formula "='Sheet2'!D1"
In Sheet1!A2 i have the formula "='Sheet2'!H1"
In Sheet1!A3 i have the formula "='Sheet2'!L1"
Now the Sheet1!Ax increments with +1 value; The Sheet2!D repeats again with D, H, L but only with a +4 to all 3 of them
[Code]...
I have one table from where two comboboxes get their drop down lists, showing info that has been entered into the table (boxes are bound to the table columns I.E City (Box1) and Country (Box2). what I would like to do is if a city is selected in box1 then box2 will autofill with the country name.
View 3 RepliesI want to multiply or add the values of two or more cells in a datagridview control in a row and and should also be auto-saved in the database after entering datas in the cell. I am using SQL Server 2008 for my database.
View 32 RepliesI want all the contents both in columns and rows to auto resize its length depending on the length of text that is to appear in the cell...but it seems I cant get the idea on how to properly use the auto size method.
View 1 RepliesSo, I am already able to successfully import an excel file to sql server through my vb application BUT I want to automatically change a value in a certain column to another. To expand on this, my excel file has a column that lists test titles such as "WCOB 1120 Access Test". I want to have each specific test title changed to a number. So, "WCOB 1120 Access Test" would need to be changed to '1' before it is added into my database.
Public Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myPath As String = sFilePath & sFileName
Dim ExcelConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" [code].....
I want to create an algorithm or formula that gives me the following combinations below. I have manually printed out all the combinations for the example containing 4 tables with respective values.
This is not permutation because i need the combinations to always follow the unique format [code]...
Does anyone know how I can include an existing dimensioned integer in VB code in a formula when using location indices (either R2C2 or R[2]C[2])?
I have integer Location set to the value 6 in some earlier programming steps, and now I'd like to be able to create other formulas and someimes use this Location integer into these formulas. More specifically at the RC and R[]C[] locations in formulas.[code]...
I have a question with jagged array, every element can contain strings, be empty or be nothing.
I would like to create a jagged array and put some strings into its cells.
Public Sub S1 ()
Dim MyArr(7)() As String ' OK
MyArr(1) = New String(8) {} ' OK the second cell contains 9 subcells
[Code].....
We want to create an makro who change all cells who has an hyperlink ex." \serversubsub3example.pdf" to \newserversubexample.pdf. All cells have different pdf´s who they are link to. Not alls cells have hyperlink.
View 1 RepliesI am converting a VB6 app to VB.NET The VB6 starts Excel to create a report.On several cells, the VB6 code does this:
[Code]...
I want to place two radio buttons in so I can select one of them to use one formula, and then select the other to use another formula. I want to use the I=P(1+r)^n formula and I=P(1-r)^n formula with the radio button text showing Appreciation and Depreciation.
Heres my copy of the original code.
Public Class Form1
Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
End
End Sub
[CODE].......................
My 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 making an twitter app. but i'm having a problem..In my listbox there is a list of username's i have to sent a tweet.this is the code i'm using:
For i As Integer = 0 To ListBox1.Items.Count - 1
ListBox1.SelectedIndex = i
Dim value1 As String = ListBox1.SelectedItem.ToString
Dim value2 As String = value1.Replace("http://twitter.com/", "")
[code]....
but it doesn't work..it goes super fast and only fills in the last listboxitem.i want now that every 10 secs a new listbox item is filled in in the status box on twitter and posts the tweet.
I'm working with referenced VB6 DLL's. The problem is that the results of a method/function call are not the same. Below the code examples:
First VB.Net Dim Validations() As String myErr = myEntry.ValidateLine(Validations)
When validation fails, the string array Validations is filled with the error description string. I've tried to accomplish the same in C#:
private string[] valArray = null;
sdkError = sdkEntry.ValidateLine(valArray);
Does anyone have an idea why I can't get C# to fill the string array? Additionally, the function in VB is called with ref to a System.Array ValidateLine(ref System.Array ValErrors), perhaps it has something to do with this?
I want to change the color of the progress that fills the progressbar, its default is green but i would like to change it to red or any other color if possible.
View 9 RepliesIm trying to make an application that fills out personal information.
Such as Name, Birth of year, etc
I want to write a quick program that fills a 2D array with quiz scores. Consider there is 5 Students and each have completed 3 Quizes. I want the program to display a class average as well as a student average.
I've gotten as far as a nested for/next loop but I am stumbling over the language for accumulating and displaying the average.[code]...
how do you make a richtextbox scroll down automatically when text fills the screen so that the new line can be seen,
View 2 RepliesI'm making a program where the user fills out info, then they click one button and the program takes a screenshot of the form, then they click another button and the screenshot gets saved. I'm having a couple problems with my code though. For one, I'm trying to make the screenshot go to an invisible picturebox to make saving easier, but I cant figure out how to make the image go to the picturebox. The other problem is that I want it to automatically save without showing the dialog, but so far, it won't save.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
TakeShotOfScreens()
Picturebox1.image=allscreenscapture
CODE:...........................
I've created a polygon shape and filled which fills blue on startup.Upon toggling a check box it should be filled yellow.It doesn't go yellow (unless i step through in debugging).
[Code]...
I would like to make an Auto Updater like this one on this thread: [URL] but without having to click on any buttons to update the files... I just want my launcher to update users's files when they start it... As I am beginner in VB.net (I started like two days ago) I really don't know how to code all this!
[Code]...
How can I create auto-cad dwg or dxf files with vb.net
View 2 RepliesWhat I have is two command buttons and one textbox, and what I want this program to do is make a mouseclick according to the time inserted into the textbox (in milliseconds). e.g say someone types in "500", after button 1("START") is clicked, the mouse will click every 500 milliseconds, and button 2 ("STOP") will halt execution. Also, would this continue execution in the background, if i have other programs open?
View 1 RepliesI am developing an application, for a university project, which is using GDI to draw a flag, my application is also equiped with an undo stack, which is, essensially, where the problem is, so what happens is: I push the draw button to draw a box, when I do that, the solution normally creates the box and stores the object to the undo stack; however, when I ask it to undo the box, and refresh the panel, it randomly adds, endless threads to the undo stack, additionally, everytime that I set the panel to refresh in the undo procedure, it affects the draw procedure; therefore, when I tell it to draw a box, it fills the undo stach with five threads at a time, sometimes, it fills it with much more than five, and sometimes it keeps filling up the undo stack, untill I stop the debugging proccess. This is my code:
[Code]...
How to create a string auto Increment like this
For Example.
NTAA001
NTAA002
....
....
[code]....
as I'm starting at this I'm very confused trying do this stupid code in visual basic 2008 in .net : Each time i create an instance of clsTest (for example) i would like to do an attribute call mID that adds 1
For example:
instance 1-
mName = test1
[code].....
I have a VB .NET (VS 2008) application which allows the user to drag and drop a xls file onto the form and a DataGridView fills with the xls sheet data. The user than can apply changes to the data or add entries. Data integrity is checked during the load into the DataGridView (duplicates are removed and invalid entries are filtered out). After doing all this the user can click a button and the data is uploaded to a SQL server (2008) DB. I have a primary key set up (row number) and I have a compound key in the SQL table.
It is all working beautifully. Now here is my question:
I want to check for duplicate entries (between SQL server and DataGridView data) before the data is uploaded and commited to the table. What would be the most efficient way to that?
I'm trying to create an interface that automatically implements a fully typed out method in VB.Net
However, I can't figure out how to do it.
I wanna do something that's similar to what happens when you implement IDisposable, where it gives you the full function, including codes and comments.
I know how to make a code snippet and how to use the tab shortcut, but how can I make the code snippet automatically appear when I implement my own interface?
I try to create an auto start up program with a check box in VB.Net 2008.How do I create a check box that when I check the check box and press apply button, the check box will always checked next time I run the program and vice versa? [code]
View 2 Replies