Replies

Yep
That did it. I thought it must have been a range issue
Thanks for all your help

Paul
Looks really good but the macro to insert a new row only fires for the first instance of inserting a new row

Paul
In the attached I believe the code for the fields is correct and input using Ctrl F9 for all brackets. However, When I select a value in cells C & D it fails to calculate in cell E. Similarly for cell H which is also giving a Syntax error message when the code is identical to that in cell E.

46760-Hazard-Identification-2
Can you help?

The fields are not calculating as required despite adding this code
‘Update the bookmarked range
.Bookmarks.Add Name:=StrBkMk, Range:=Selection.Tables(1).Range
.Fields.Update

Cannot figure this out as they are very basic calcs C*D & E*G

Paul
I thought I had this sorted but for some reason it just doesn’t want to behave!
46760-Hazard-Identification-2

Paul
For the life in me I cannot figure how to create the “on-exit” function for the content control. I know in older versions it was in the properties

Paul this thing is doing my head in!
I can’t seem to get the row add function to activate when I add a new row.46749-Hazard-Identification

46738-Hazard-Identification46737-codePaul
I have entered the field code using Ctrl F9 as follows

46737-code
In column H I wish to calculate E * G and then add a new row if required

Hey guys
My users now decide that wish to copy up to 3 columns of mixed text, column 1 and data columns 2 & 3, into the P&L and GIT combo boxes. I have tried with column properties set but all I get are the headers

sorry guys
Had a problem with a variable but then realised the sub where the variable was defined was set to Option Explicit!!

Thanks Andrew and Maud for all your help
Make sense

Thanks Andrew
The workbook doesn’t seem to want to behave. When I double click to open the file opens with Protected view warning with “Enable Editing” highlighted then when clicked it gives VBA error 91
44764-error91
and then when I click “Debug” I get the following
44765-91Debug

However, if I open the file from Excel it all works fine as expected. The preference is for the users to have the file on their desktop, double click to open and fill in the data.

Reviewing the code, other the initialise sub, I cannot see what you have changed plus the email function doesn’t work

Maud
Thanks for that. I have used a combination of Text Boxes and Combination Boxes on the UserForm.
I assume your code will only work for Combination Boxes

But why do you need a temp sheet to hold this info? Why can the data not go onto the “Monthly Report” until a certain point in time. Surely it doesn’t become ‘final’ until the person submits the sheet. I would be putting the info straight onto the report and not be bothered with a temp sheet to hold the same information until it needs to be transferred across.

Andrew
Not sure I understand. My users wish to enter data, save it and then come back to it later by opening the workbook again. I didn’t believe rerunning the userform retained the previously entered data, which is what my users wish to do, edit the data .

Sure