1001 Freelance Projects -- I need help with one simple bit of VBA code.

Latest Projects from Freelance Marketplaces

Today is: 05-Feb-2026 11:36 GMT

View this project in detail (Note: you will be redirected to external marketplace)
Project title:	I need help with one simple bit of VBA code.
Posted by:	External project from PeoplePerHour
Started:	10-Apr-2025 04:46 GMT
Description:	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 Me.TextBoxInstall.Value = "£" & installValue & " - £" & (installValue + 100) UpdateTextBox300 End If End Sub
Project ID:	3429191
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
We need to have a brochure revised.	05-Feb-2026 10:15 GMT
Redesign Media Pack & Create New Charity Media Pack	05-Feb-2026 10:10 GMT
New brochure for a new loyalty platform aimed at small studios	05-Feb-2026 09:18 GMT
OELN Sketch	05-Feb-2026 09:17 GMT
Clean rebuild of working 3D prototype into production-ready CAD	05-Feb-2026 06:54 GMT
Need realistic interior and exterior rendering	05-Feb-2026 06:52 GMT
Complete existing Android (Kotlin) app to match React Native app	05-Feb-2026 06:02 GMT
Frontend Developer Needed – Marketplace Platform	05-Feb-2026 05:19 GMT
CONTRACT ENGINEER (IoT / Automation / Integration)	05-Feb-2026 05:18 GMT
Recording a short on-camera video IN ENGLISH, ready-made script	05-Feb-2026 05:16 GMT
DM Setter / Conversation Manager	05-Feb-2026 05:16 GMT
Remote Inbound Call Handler (Daily Pay+Training+Referral Bonus)	05-Feb-2026 05:11 GMT
Překlad webového obsahu CZ ↔ EN	05-Feb-2026 05:11 GMT
Competition Website Setup	05-Feb-2026 05:08 GMT
Facebook Ads Expert Needed for Online Course (Motorcycle Niche)	05-Feb-2026 05:08 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com