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
SEO-Optimized Real Estate Website Category: Content Management System (CMS), Conversion Rate Optimization, Digital Marketing, Graphic Design, Internet Marketing, Real Estate, SEO, Web Development, Web Design, Website Optimization Budget: ₹1500 - ₹12500 INR
25-Jan-2026 17:04 GMT
Cálculo estructural para remodelación Category: 3D Modelling, AutoCAD, Building Design, Civil Engineering, Corporate Identity, Covers & Packaging, Graphic Design, Structural Engineering Budget: $15 - $25 USD
Build ConAcc4 Web & Mobile Category: Android, Backend Development, CI / CD, Figma, Full Stack Development, IOS Development, IPhone, Mobile App Development, User Interface / IA, Web Development Budget: $1500 - $2000 USD
25-Jan-2026 17:00 GMT
patch to detect hormones in sweat Category: Biomedical Engineering, Computational Fluid Dynamics, Data Analysis, Data Visualization, Electronics, Embedded Systems, Prototyping Budget: £750 - £1500 GBP
25-Jan-2026 17:00 GMT
Equine Rescue Grant Funding Category: Budgeting And Forecasting, Event Planning, Fundraising, Grant Writing, Project Management, Proposal Writing, Public Relations, Research Budget: $250 - $750 USD
Professional Video Editor for Instagram Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Instagram Marketing, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
25-Jan-2026 16:58 GMT
Website Content Writing at $10/hr Category: Article Writing, Content Development, Content Writing, Copywriting, Research, SEO Budget: ₹750 - ₹1250 INR
25-Jan-2026 16:57 GMT
Retail Store Operations & Growth Manager Category: Accounting, Business Analysis, Business Development, Excel, Finance, Inventory Management, Operations Management, Sales Management Budget: $30 - $250 USD
