fire

Private Sub cmdPrimary_Click() txtPrimary.text = GetFolder("Select the Primary Folder") End Sub Private Sub txtPrimary_AfterUpdate() Stop End Sub The GetFolder function returns a value which txtPrimary displays. It isn't assigned a value until then but the After Update event doesn't fire...

I have a sub which loads a splash screen. very basic. For some reason the first time I load the workbook it doesnt fire. If I close it then open it it does. Then if I restart my comp and load it again it doesnt fire. Any ideas why? Private Sub Workbook_Open() 'error 438 somewhere in here...

I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...

need formula Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year were find and put dildimeter like ^ before ^W4Z6QA69 Philadelphia Contributionship for the Insurance of Houses from Loss by Fire ^W4Z6QA69...

Hello, I'm really struggling with this one. I believe I need to use an index match lookup combo. The goal is to pull information from sheet 1 into other "forms" (pre-populated sheets) in a workbook. I would like to return all information from column C that has the correct text in columns A...

Hello, How would i fire a command WHILE a button is being clicked and then fire another command when I let go of the click? Is there a way? Thank you

Hi everyone I have a workbook that has some code in the workbook open event that does a whole load of things which is fine I also have this workbook open via code in a different workbook that just updates a cell in this workbook and then saves and closes it Is it possible that when i open...

I couldn't get these formulas to work: <tbody> =MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")) =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A5&"0123456789")) =RIGHT(A6,SUM(LEN(A6)-LEN(SUBSTITUE(A6,{"0","1","2","3","4","5","6","7","8","9"},"")))) </tbody> Data starting in...

Looking to tie the range name to cell value For example <tbody> A B C 1 2 A_Sanchez 3 1 4 3 5 7 6 6 7 2 8 1 9 </tbody> I want the name of Range B1:B8 to equal the value of B:2 This way when I Fire A_Sanchez and Hire someone else I can...

Hi, I need to fire a code when a cell in a range of J3:J1000 <> "" then fire code. What I've tried to do is this bit of code however msgbox never shows even when I populate a cell in J. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("J3:J1000")) Is Nothing...

Access 2010 I have a field called Description and need to parse a 12 space word that begins with A9B. i.e. A9B123456789012 It could have words before and after A9B123456789012. like A9B123456789012 oil mount A9B123456789012 fire missing A9B123456789012 washer A9B123456789012 I need to have...

I posted a thread about how to add to an already existing VBA Macro the other day. I basically wanted two columns in my spreadsheet to automatically add the present time with one click of the cell. The macro worked, except for the fact that if I clicked the cell again (even by accident) then it...

Hello, For some reason I can't get the Ch_MouseUp event to fire. I'm using a modified version of some code Andrew Poulsom provided to another user to display labels when the mouse is clicked down and then have them not visible when the mouse button is released. However, I have it working so...