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 Astrophysics Documentary Category: 3D Animation, After Effects, AI Animation, AI Art Creation, AI Content Creation, AI Model Development, Motion Graphics, Video Editing, Visual Arts Budget: $5000 - $10000 AUD
06-Apr-2026 16:04 GMT
Modern Vibrant Hat Embroidery Category: Adobe Illustrator, Photoshop, Embroidery, Graphic Design, Logo Design, T Shirts, Vector Design Budget: $2 - $8 USD
06-Apr-2026 16:03 GMT
Minimalist Box Packaging & Video Category: 3D Rendering, Adobe Illustrator, Adobe Premiere Pro, After Effects, Graphic Design, Logo Design, Packaging Design, Video Editing Budget: $30 - $250 USD
06-Apr-2026 16:03 GMT
Data Analysis Specialist Needed Category: Data Analysis, Data Analytics, Data Visualization, Pandas, Python, SPSS Statistics, Statistical Analysis, Statistics Budget: ₹600 - ₹1500 INR
Roof Antenna Structural Assessment Category: AutoCAD, Building Architecture, Building Certification, Building Design, Building Engineering, Building Surveying, Civil Engineering, Construction, Risk Assessment, Structural Engineering Budget: $250 - $750 USD
06-Apr-2026 15:58 GMT
Forensic Video Analysis Category: Data Analysis, Forensic Consulting, Technical Writing, Video Editing, Video Processing, Video Production Budget: $30 - $250 USD
06-Apr-2026 15:57 GMT
Bank SBLC for Loan Security Category: Compliance, Financial Consulting, Financial Planning, Investment Banking, Risk Management Budget: $50000 - $100000 USD
06-Apr-2026 15:56 GMT
Urgent Private Credit Site Launch Category: Chatbot, CSS, HTML, JavaScript, Lead Generation, PHP, Web Design, Web Development, WordPress Budget: $30 - $250 AUD
