Im stuck with some code in VBA. Every time i manually change the value in textBox20 it resets when i hit the SaveQuote button. The subroutine ComboBox20_Change is being triggered programatically elsewhere in the project that is doing it and i cant figure out how to stop it.
Private Sub ComboBox20_Change() If Not isUserChange Then Exit Sub ' Only proceed if the user triggered the change
Dim ws As Worksheet Dim lookupValue As String Dim result As String Dim qValue As String Dim installValue As Double Dim Rng As Range Dim cell As Range Dim found As Boolean
Me.TextBox2000.Value = 1 Me.TextBox3000.Value = 1
Set ws = ThisWorkbook.Sheets("GHMatrix") lookupValue = Trim(Me.ComboBox20.Value)
If lookupValue = "" Then Me.TextBox200.Value = "" Me.TextBox20.Value = "" Me.TextBox300.Value = "" Me.ComboBox30.Value = "" Me.TextBox30.Value = "" Exit Sub End If
found = False For Each cell In ws.Range("H1:H" & ws.Cells(Rows.Count, "H").End(xlUp).row) If Trim(cell.Value) = lookupValue Then Set Rng = cell found = True Exit For End If Next cell
If found Then result = ws.Cells(Rng.row, 1).Value qValue = ws.Cells(Rng.row, 21).Value installValue = ws.Cells(Rng.row, 22).Value
Me.TextBox200.Value = result Me.TextBox20.Value = qValue
One-Time Web Data Extraction Category: BeautifulSoup, Data Extraction, Data Management, Data Mining, Data Processing, JavaScript, Python, Scrapy, Selenium, Web Scraping Budget: $75 - $300 USD
10-Feb-2026 23:00 GMT
3D Monster Modeling and Rigging Category: 3D Animation, 3D Art, 3D Design, 3D Illustration, 3D Modelling, 3D Rendering, 3D Rigging, 3D Visualization, Blender, Maya Budget: $30 - $250 CAD
10-Feb-2026 22:55 GMT
Modern Sleek Instagram Car Dealer Theme Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Instagram Marketing, Logo Design, Social Media Management, Visual Design, Web Design Budget: £20 - £250 GBP
10-Feb-2026 22:54 GMT
Cricket Prediction Web App Development Category: Frontend Development, UI / User Interface, Web API, Web Application, Web Design, Web Development Budget: ₹75000 - ₹150000 INR
10-Feb-2026 22:54 GMT
Source UK Council Sector CVs Category: Data Entry, Excel, Human Resources, Recruitment, Talent Acquisition Budget: £20 - £250 GBP
10-Feb-2026 22:54 GMT
Investment Climate Assessment for Philippines Category: Business Analysis, Business Writing, Financial Analysis, Investment Research, Market Research, Report Writing, Research Writing, Risk Management Budget: $30 - $250 USD
10-Feb-2026 22:53 GMT
Spec Home 3D Walkthrough Category: 3D Animation, 3D Modelling, 3D Rendering, 3D Studio Max, 3ds Max, Architectural Visualization, Lumion, V Ray Budget: $250 - $750 USD
Tableros Power BI y Mantenimiento Category: Business Intelligence, Data Analysis, Data Integration, Data Management, Data Modeling, Data Visualization, Power BI, SQL Budget: $8 - $15 USD