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
French AI Automation Setup Category: AI Content Creation, AI Development, AI Model Development Budget: €30 - €250 EUR
03-May-2026 10:01 GMT
Figma UI/UX Designer for FMCG Dashboard Category: Figma, Graphic Design, Logo Design, UI / User Interface, User Experience Research, User Interface / IA, User Story Writing, UX / User Experience Budget: $250 - $750 USD
03-May-2026 10:01 GMT
Data Mining for specific Business Services Category: Amazon Web Services, Business Intelligence, C++, Programming, Data Analysis, Data Governance, Data Mining, Java, Software Architecture Budget: $250 - $750 AUD
Λογισμικό Οικονομικής Διαχείρισης Επιχείρησης Category: Business Analysis, Data Integration, Data Visualization, Financial Analysis, Project Management, Software Development, User Experience Research Budget: €250 - €750 EUR
Indian YouTuber Affiliate Partnership Category: Advertising, Affiliate Marketing, Content Creation, Digital Marketing, Facebook Marketing, Internet Marketing, Social Media Marketing, YouTube Budget: ₹600 - ₹1500 INR
03-May-2026 09:51 GMT
Sales-Focused Email Marketing Specialist Category: A / B Testing, Content Marketing, Customer Retention, Digital Marketing, Email Marketing, Internet Marketing, Klaviyo, Lead Generation, Mailchimp, Marketing Budget: $30 - $250 USD
Live Order Flow Coaching Category: Financial Markets, Market Analysis, Risk Management, Trading Budget: $10 - $30 CAD
03-May-2026 09:47 GMT
Need graphic desginer Category: Adobe Illustrator, Photoshop, Branding, Business Card Design, Digital Design, Figma, Graphic Design, Illustration, Logo Design, Print Design Budget: ₹37500 - ₹75000 INR
03-May-2026 09:46 GMT
User Referral Campaign India Category: Content Marketing, Digital Marketing, Email Marketing, Influencer Marketing, Lead Generation, Market Research, Social Media Management, Social Media Marketing Budget: ₹12500 - ₹37500 INR