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
Realistic AI Images for Personal Use Category: AI Design, Graphic Design, Illustration, Midjourney, Photoshop, Stable Diffusion Budget: $10 - $30 USD
27-Dec-2025 23:02 GMT
Gym Outreach App Download Promoter Category: Event Planning, Facebook Marketing, Internet Marketing, Lead Generation, Market Research, Marketing, Sales Promotion, Social Media Marketing Budget: $15 - $25 USD
27-Dec-2025 23:02 GMT
Energetic Reels Video Editing Category: Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Video Editing, Video Post Editing, Video Production Budget: $10 - $30 USD
27-Dec-2025 22:57 GMT
Create Miracle-Testimony YouTube Videos Category: Animation, Content Creation, Ghostwriting, Script Writing, Video Editing, Video Services, Videography, Voice Over Budget: €30 - €250 EUR
Article and Blog Content Writer Category: Article Rewriting, Article Writing, Blog Writing, Content Writing, Copywriting, Editing, Ghostwriting, Proofreading, SEO Writing, Travel Writing Budget: $15 - $25 USD
27-Dec-2025 22:49 GMT
Meta Ads for E-Commerce Course Category: Advertising, Content Creation, Digital Marketing, Facebook Ads, Graphic Design, Instagram Marketing, Social Media Marketing, Video Editing Budget: £10 - £20 GBP
27-Dec-2025 22:45 GMT
holding company website Category: CMS, Elementor, Graphic Design, HTML, PHP, Web Design, Web Development Budget: $250 - $750 USD
27-Dec-2025 22:45 GMT
Brand Awareness Social Media Campaign Category: Branding, Content Creation, Content Strategy, Facebook Marketing, Instagram Marketing, Social Media Marketing, Twitter Budget: $250 - $750 USD
27-Dec-2025 22:45 GMT
Residential Structural Design Project Category: Architecture, AutoCAD, Building Architecture, Building Design, Civil Engineering, Construction Management, Engineering Drawing, Structural Engineering Budget: $30 - $250 USD
