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
Decision Model Designer for Business Tools Category: Business Analysis, Business Intelligence, Data Analysis, Data Modeling, Data Processing, Data Visualization, Financial Analysis, Financial Modeling, Statistical Analysis, Statistics Budget: €12 - €18 EUR
02-Jan-2026 23:04 GMT
High-Conversion WordPress Landing Pages Category: A / B Testing, Conversion Rate Optimization, HTML, JavaScript, Landing Pages, Lead Generation, PHP, WordPress Budget: £5 - £10 GBP
Create Saudi Google Maps Listing Category: Content Marketing, Digital Marketing, Google Analytics, Google Maps API, Google Search, SEO, Social Media Marketing, Website Optimization Budget: $30 - $250 USD
UI/UX Designer (React, TypeScript, MUI, Tailwind) -- 2 Category: CSS, Frontend Development, Graphic Design, Tailwind CSS, UI / User Interface, User Experience Research, User Interface / IA, Web Application, Web Design Budget: ... (Budget: ₹600 - ₹1500 INR
02-Jan-2026 22:48 GMT
Product Documentation Writer Needed Category: Business Analysis, Data Analysis, Data Analytics, Documentation, Report Writing, SaaS, Technical Writing Budget: €12 - €18 EUR
02-Jan-2026 22:46 GMT
Google and Instagram Ads lead generation Category: B2B Marketing, Conversion Rate Optimization, Facebook Ads, Google Ads, Instagram Ads, Lead Generation, Social Media Marketing Budget: $30 - $250 USD
02-Jan-2026 22:46 GMT
AI-Powered Media Plan Automation Category: AI Chatbot Development, AI Model Development, AI Text To Text, Graphic Design, PostgreSQL, Powerpoint, Python, Software Architecture Budget: $30 - $250 USD
02-Jan-2026 22:45 GMT
Judicial Speech Bias Analysis Category: Attorney, Audio Engineering, Audio Processing, Data Analysis, Data Visualization, Legal, Linguistics, Natural Language Processing, Statistical Analysis, Transcription Budget: $250 - $750 USD
