+ Reply to Thread
Results 1 to 2 of 2

Struggling to use number entered in text in calculation

  1. #1
    Registered User
    Join Date
    06-14-2008
    Posts
    5

    Unhappy Struggling to use number entered in text in calculation

    I have created a form which has a combobox, a text box and a submit button. I want that a person should choose an item from combo box, enter a number in text box and then when one clicks submit button, the value in combo must be checked for in a cell or a range (I tried cell as ranged looked a bit complicated) and if the value selected form Combo box is equal to the value in the cell specified( or is present in the range), then, it should go to another sheet and add the value inside text to an existing value in a specific cell (that is the range name).

    I coded like this:
    Private Sub CommandButton1_Click()





    With UserForm2
    If ComboBox1.Value = Worksheets("Sheet3").Range("D2").Value Then
    Set j = UserForm2.TextBox1.Value
    Worksheets("Sheet4").Range("B2") = Worksheets("Sheet4").Range("B2") + j
    End If

    End With
    End Sub


    Unfortunately, I am stuck and unable to understand the error, it says object missing...which object is it talking about?

    Please help me with this coding

  2. #2
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Struggling to use number entered in text in calculation

    So are you trying to add J to the range to make if move farther down?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Percentage calculation based on number entered
    By Brewha51 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-29-2013, 01:33 PM
  2. Look up the corresponding number based on the entered text
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2012, 08:32 AM
  3. Entered text value equals a number I specify in another cell
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  4. Entered text value equals a number I specify in another cell
    By Dave S. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Entered text value equals a number I specify in another cell
    By Dave S. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1