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
AI Animated Marketing Videos Category: 2D Animation, 3D Animation, After Effects, AI Animation, AI Content Creation, Animation, Motion Graphics, Video Production Budget: ₹1500 - ₹12500 INR
Tally to Odoo Data Migration Category: Data Cleansing, Data Integration, Database Management, ERP, MySQL, Odoo, PostgreSQL, Python Budget: ₹600 - ₹1500 INR
22-Mar-2026 10:54 GMT
Personal Story Blog Setup Category: CMS, HTML, PHP, SEO, Web Development, Web Design, Website Management, WordPress Budget: ₹750 - ₹1250 INR
22-Mar-2026 10:53 GMT
Family Friendly Gaming Zone Promo Category: After Effects, Animation, Content Creation, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services Budget: $1500 - $3000 USD
22-Mar-2026 10:48 GMT
Modern College Webpage HTML Design Category: CSS, CSS3, Frontend Development, HTML, HTML5, JavaScript, Web Design, Web Development Budget: ₹750 - ₹1250 INR
22-Mar-2026 10:47 GMT
Juego de mesa en GDevelop Category: 2D Game Art, Animation, Data Entry, Game Design, Game Development, JavaScript, Software Architecture Budget: €250 - €750 EUR
