Home » VB.Net

Goal Seek Function in Visual Basic.Net


In excel i use the Goal Seek Function but i want to use it on a Visual Basic.net Application.

I need the formula used to calculate the Goal Seek or something that can replicate the Function.

Thanks For all the help !


3 Answers Found


Answer 1

Hello, iLM

It seems your question is a development question more than a visual  studio editor question, So next time please post your question in Visual Basic general forum.


I think you may try Crystal report to use this feature.




Answer 2

Hello, iLM

You could try crystal report or use visual  studio Report controls, you could create formula on both of these controls. See the following link about how to create formular on Crystal report control.


And there are two specific forums for both of the controls, if you have anything unclear, you may post in the following websites.



Hope this helps






Answer 3


I will close this thread by marking my reply as answer, if this does not help, feel free to let me know and unmark it.


Please unmark it if it does not help, and mark it if it helps.

I am new to programming and have just finished one of my first projects. I would like to possibly sell this application, but I need to figure out how I'm going to get the app. protected.

I plan on selling the program as a digital download and was wondering what the steps would be to issue serial licenses to the people who will purchase it.

Can anyone please direct the first few steps? It would be greatly appreciated.

Aaron C.

Hello, I am 14 and I hope to be a software programmer when I am older, hopefully a game programmer.

Previously I had done just markup languages like HTML and CSS and web scripting like Javascript, and some engine scripting for a Visual Basic 6 game engine (it was called Sadscript for the "Eclipse" engine. Here is an example of a game made with it.)


About a year ago I started some C++ tutorials and saw that it was very complicated. I only made a few console programs that would ask you your age and print it back to you ect...


Recently I picked up Visual Basic 2010 Express, Visual C# 2010 Express, Visual C++ 2010 Express, and XNA Game Studio 3.1.

I have done the Visual Basic picture viewer, maze game, and maths quiz tutorials and they worked, so I have a VERY BASIC understanding of Visual Basic so far. I have also made a few basic console apps in C++.


If I want to start a programming language to eventually become a game developer, should I:


Start With Visual Basic .NET, then move on to C# (without XNA), then C# with XNA, then C++. Start with C#, then move on to C# with XNA, then C++, ignoring Visual Basic .NET.
This would be done over a number of years, and I am willing to pick up books and dedicate time to these.

Please help me choose what to do (:



What are my options when I need serial port support but have the first version of Visual Studio. Net 2002 where there is no serial port support. What version of Visual Studio will I need.

Thank you


Hey everyone,

This is my first post here, and it looks like a great community, with lots of generous help available!

I am just delving into ASP.NET and the .NET framework and it appears to be a little daunting at first.

What is the deal with having to choose a language for ASP.NET?

Isn't ASP.NET already a web server language itself?

Can you also choose JavaScript like you could in Classic-ASP?

Isn't C# more for offline development anyway?

I'm just trying to get a feel here, because this concept appears to be rather new to me! Foot in mouth

Any help is greatly appreciated!




I had VB2008 Express on my machine, registered.

I previously installed and used MS Visual Basic 2010 Express beta 2 ENU on XP SP3 machine.

Now it asked for Registration. So I tried. It complained I sould update to full 2010 release. So I tried this.

It didn't succeed. It complained about old beta 2 ENU Components that need to be uninstalled.

I removed everything named 2010 in Systems software.

I updated .net 4.0 beta 2 to full .Net 4.0.

Still it doesn't install. It still complains about old beta 2 ENU components I now cannot find.

What else should I do?

I think this Issue is relevant to all that installed VB 2010 beta 2 ENU

Thank You for any advice!


I'm writing a small program to manipulate an Excel spreadsheet.

I need to be able to AutoFilter a certain 'list' of telephone extensions in my company.


I'd like to sort by three extensions, lets say, 116, 119, and 122.

This is exceptionally easy inside of Excel as:

 ActiveSheet.Range("$A$1:$N$34").AutoFilter Field:=1, Criteria1:=Array("116" _
  , "119", "122"), Operator:=xlFilterValues
 Application.Goto Reference:="Macro1"

However, I cannot get this to work in Visual Basic 2010.

I tried the following:


Dim myAl(0 To 2) As String
  myAl(0) = "116"
  myAl(1) = "119"
  myAl(2) = "122"

  oSheet.ListObjects.AddEx(Excel.XlListObjectSourceType.xlSrcRange, oApp.Range("$A:$H"), , Excel.XlYesNoGuess.xlYes).Name = "Calls"

  oSheet.ListObjects("Calls").Range.AutoFilter(Field:=1, Criteria1:=myAl)

However this resulted in the Excel sheet only filtering the final entry in the array.

Anyone able to offer some insight into what I'm doing wrong?


Hye peeps...


I just work out my interface and coding (attached)

the problem is.. i have 1 btnDelete but still not working... i want the Delete button clicked to delete the whole row record..

anyone can gimme example?


interface :



the code :

Imports System.IO
Public Class Form1
    Private headers() As String = Nothing

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        SetUpHeaders("Folder Path,Folder Name,Photo Name,Date Taken,Location,Weather Condition")
        txtSource.Text = "C:\textfile\records.txt"
    End Sub
    Private Sub SetUpHeaders(ByVal headerLine As String)

        headers = headerLine.Split(","c)
        For Each h As String In headers
            Dim column As New ColumnHeader()
            column.Text = h
            column.Width = 102
    End Sub

    Private Sub AddToListView(ByVal dataLine As String)
        Dim data() As String = dataLine.Split(","c)
        Dim it As New ListViewItem()
        it.Text = data(0)
        For i As Integer = 1 To data.GetUpperBound(0)
    End Sub

    Private Sub WriteHeaders(ByVal writer As StreamWriter)
        Dim s As String = headers(0)
        For i As Integer = 1 To headers.GetUpperBound(0)
            s &= "," & headers(i)
    End Sub

    Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
        Using sr As New StreamReader(Me.txtSource.Text)
            Dim inputLine As String = sr.ReadLine()
            While Not inputLine Is Nothing
                inputLine = sr.ReadLine()
            End While
        End Using
    End Sub

    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        Using sw As New StreamWriter(txtSource.Text)
            For Each it As ListViewItem In lvwData.Items
                Dim outputLine As String = it.Text
                For i As Integer = 1 To it.SubItems.Count - 1
                    outputLine &= "," & it.SubItems(i).Text
        End Using
    End Sub

    Private Sub lvwData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lvwData.SelectedIndexChanged
        Dim its As ListView.SelectedListViewItemCollection = lvwData.SelectedItems
        For Each it As ListViewItem In its

            cboPathName.Text = it.SubItems(0).Text
            txtFolderName.Text = it.SubItems(1).Text
            txtPhotoName.Text = it.SubItems(2).Text
            txtDateTaken.Text = it.SubItems(3).Text
            txtLocation.Text = it.SubItems(4).Text
            cboWeatherCondition.Text = it.SubItems(5).Text
    End Sub

    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        Dim its As ListView.SelectedListViewItemCollection = lvwData.SelectedItems

        its(0).SubItems(0).Text = cboPathName.Text
        its(0).SubItems(1).Text = txtFolderName.Text
        its(0).SubItems(2).Text = txtPhotoName.Text
        its(0).SubItems(3).Text = txtDateTaken.Text
        its(0).SubItems(4).Text = txtLocation.Text
        its(0).SubItems(5).Text = cboWeatherCondition.Text
    End Sub

    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
        Dim it As New ListViewItem
        it.Text = cboPathName.Text
    End Sub

    Private Sub txtDateTaken_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs)
        If Not IsDate(txtDateTaken.Text) Then
            e.Cancel = True
            MsgBox("Please enter a valid date")
        End If
    End Sub
End Class



After store/save the detail in text file I may well to delete or modify information on the text file. And i'll need to have the facility to search the file for folder paths to photographs that meet the following simple criteria:
• A specific file name.
• Names of files that contain a specific string.
• A specific date.
• A range of dates.
• A specific location where the photographs was taken.
• A particular weather condition.

maybe i need to do this by a new windows form....


How do you extract source code from a VB.NET .EXE file?

I am a newbie to CCF, as the subject implies. This means I have installed the beast (CCF 2009) and all the stuff it is dependent upon. I have read a bit about it.

My ultimate goal is to integrate legacy applications with a web page. For now, I'd like to actually see something happening.

Is there some place online where one can get at a simple move by move tutorial on how to use CCF from withing Visual Studio (I'm using Visual studio 2005) to run a simple legacy application (I don't care if the simple application it is form with a text box hastily concocted by myself in VB or whatever) from within the agent desktop (the "thing" that I believe will visually aggregate my stuff)?

Thank you very much, to whoever can help me. It seems a great technology, but simple tutorials seem to be scarce...

Jorge de Abreu

I am a freelancer, and am currently looking to migrate all my code on different technologies to a single Source Control system. I am currently deliberating between choosing SVN or TFS Basic (I considered Git also, but that does not seem to have good Windows & VS integration at this point).

I primarily develop from a single Win 7 machine, which would have both the Source Control server and the clients setup. Is TFS a worthwhile option in my scenario?

Also, is TFS bundled with VS 2010 Ultimate setup??

Looking to learn VB.net (beginner here) for the object oriented programming of the program I use for work (Civil3D 2010).  Those forums state learn VB.net.  I just bought MS VB 2008 Step by Step and going thru the chapters.  The questions I have are.  Is there a difference between (and in programming) VB2K8 vs VB.net?  Am I wasting my time with this book?  If VB.net is what I want, which book would be good for me to start with? I also bought the MS Visual C# 2008, which I planned on reading after the VB 2K8.  Would like to get on the fast track for Vb.net programing.


can i know what .net framework is required for my application that has been developed under Microsoft Visual Basic 2010 Express.



I already have installed Visual Studio 2008 but was configured to go with SQL Server 2008, thus the menu for VS 2008 will be for SSIS, SSRS. How can I add Visual C++ and Visual Basic?




i like to know why they didn't think of maybe someone wants to make a program that can write a CD or DVD

i searched the entire net trying to find a single program made by visual basic .net


i found 4 but non of them worked they had some problems the last one made windows to write the files instead of it

i just want to make a program that can burn files please make a code or a program that can do that or try to add something like that in vb.net





Dear sir,

     I am a student and i am making a windows application in vb.net 2005. My project requrement is to print form's specific area and also provide left, right, top and bottom margin. It will also print in multi page if it require. For that i used Microsoft PrintForm Component 1.0. But it is not working.

So for my problem please provide me code solution or any other component.

Thanx and regards

Abhishek Dubey

I want to terminate a process by calling TerminateProcess via "kernel32".
I builded up the code below but there is an error. How can I fix that?
Thank You!
PrivateDeclareFunction TerminateProcess Lib"kernel32" (ByVal hProcess AsLong, ByVal exitcode AsLong) AsLong
    PublicDeclareFunction OpenProcess Lib"kernel32" (ByVal dwDesiredAccess AsLong, ByVal blnheritHandle AsLong, ByVal dwAppProcessId AsLong) AsLong
    PublicDeclareFunction CloseHandle Lib"kernel32" (ByVal hObject AsLong) AsLong
    PrivateConst PROCESS_ALL_ACCESS = &H1F0FFF
    Sub RandomName(ByVal id AsInteger)
        Dim hprocess AsLong
        Dim exitcode AsLong
        hprocess = OpenProcess(PROCESS_ALL_ACCESS, False, id)
        Call CloseHandle(hprocess)
        exitcode = Process.GetProcessById(id).ExitCode 'InvalidOperationException was unhandled: Process must exit before requested information can be determined.
        TerminateProcess(hprocess, exitcode)
    Sub ButtonCall_Click() Handles Button2.Click


I need to remove VB .Net Standard 2002 installation from a XP SP3 laptop I used for development.  Unfortunately I threw away the installation disk which came with a VB MSPress Manual.  I have read and followed the advice in KB Articles 312383, 320114 and 319714 with no success.  The MSIs would not even run in admin mode.  Has anyone removed this product without the installation disk?  Is there a source for a detailed list of the files and folders I must manually remove?

When none of the appraoches in the KB articles helped, I uninstalled all the Versions of Framework and got closer to getting rid of the app.  It still asks for the source disk or gives a missing file error when I attempt to use the MSI file to directly remove it.

Much of the product software appears to be installed in separate VS and VB subfolders in "Program Files"  I could delete these folders then run MSIZAP to clean up the Registry.  Does this sound reasonable?


Hi, I'm trying to upgrade my VB6 program to VB 2008 express
and the IDE is VERY SLOW. I saw patch for this but it cannot be install
because it's for the complete Visual Studio and I only have the Express Edition.
What Can I do?



Hi Friends!

I am trying to build my own website and realized that it would be a big help to also create my own vb program to enable me to embed tags with simple clicks of buttons. I am having trouble getting my vb code to be compatible with html code (I keep getting vb syntax errors).


Here is what I've tried:

<strong>'Inside of a button:
Textbox1.text = "<html tag example></html tag example>"</strong>

So I am looking for a quick code snippet to make html tagging compatible with my vb code.


Here is an example of a program that I'm trying to code my project similar to:




Any code snippets would be greatly appreciated!





I am using Visual Studio 2005, the information is listed as below.

Microsoft Visual Studio 2005
Version 8.0.50727.762  (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP2

When I rebuild the project, an error occuried.

Error	3	The assembly 'Microsoft.VisualBasic, Version=, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' is not registered for COM Interop.
Please register it with regasm.exe /tlb.
So I followed the http://support.microsoft.com/kb/316163 to register microsoft.visualbasic.dll, and the types registered successfully.

However when I switch back to Visual Studio .NET or Visual Studio 2005, and then rebuild the project. The error is still coming to me.

Help will be appreciated.

<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure