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
Videomaker para Marca de Cuidado Capilar Category: Catch Phrases, Content Creation, Instagram Marketing, Slogans, Social Media Marketing, Video Editing, Video Production, Videography Budget: €30 - €250 EUR
02-Apr-2026 15:59 GMT
Specjalista Meta Ads do E-Commerce Category: Advertising, Content Creation, Conversion Rate Optimization, Digital Marketing, Facebook Ads, Graphic Design, Instagram Marketing, Social Media Marketing Budget: $30 - $250 USD
02-Apr-2026 15:59 GMT
Senior Data Scientist for Advanced LLM Workflow Category: A / B Testing, Artificial Intelligence, Data Analysis, Data Science, Hadoop, Machine Learning (ML), NumPy, Pandas, Python, SQL Budget: min $50 USD
West Bank Human Rights Calls in Arabic Category: Arabic Translator, Data Entry, Legal Research, Public Relations, Research, Research Writing Budget: $2 - $8 USD
02-Apr-2026 15:57 GMT
Modern Logo & Font for Fordj Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design Budget: $10 - $30 AUD
02-Apr-2026 15:57 GMT
ITR Filing Website Development Category: Database Management, Full Stack Development, HTML, MySQL, PHP, Security, Web Development, Web Design Budget: ₹1500 - ₹12500 INR
02-Apr-2026 15:57 GMT
Company Site Verification in Jasło, Poland Category: Data Collection, Data Entry, Geolocation, Internet Research, Photo Editing, Photography, Remote Sensing Budget: $70 - $80 USD
02-Apr-2026 15:56 GMT
Micro task specialist Category: Copy Typing, Customer Service, Data Entry, Data Processing, Project Management, Research, Statistics, Time Management, Web Search Budget: $15 - $25 USD
ERP System with Mobile App for Manufacturing Category: Accounting, Android, Data Analytics, ERP, Inventory Management, IOS Development, IPhone, Mobile App Development, Odoo, PHP Budget: ₹1250 - ₹2500 INR
02-Apr-2026 15:51 GMT
Kundali System Repair on WordPress Category: API, Database Design, Database Management, MySQL, PHP, Web Development, WordPress Budget: ₹2000 - ₹3000 INR