Posts by ian mason

Re: Sum With Multiple Criteria

JMAN

Why don't you use the employees full name as (LNAME) instead of just their last name?

Ian

Re: Insert Row Data And Sort

Upside

Try the attached

Ian

Re: If Function To Return One Of 3 Results

=IF(AI9="","",IF(AH9>AI9,"Green",IF(AH9=AI9,"Blue","Yellow")))

Re: Generate Holidays Left Based On Start Date

Kevin

Have a look at the attached, hope it helps.

Regards

Ian

Re: Automatic Code Selection Based On Drop Down Menu?

Claire C

As Stephen said it would be easier if the lists were in 2 columns.

I have attached an example using your sheet with a new "Tab" called "LOOKUP" and 2 new "Named Ranges" called "expcode" and "CC". have a look.

Regards

Ian

Re: Multiple Condition Macro

Thunderstrai

I have attached a new sheet sorting out the problem with "less than 69%".

With regard to the other request, you can copy the formula down as far as you need.

Regards

Ian

Re: Look Value With X And Y Criteria

Pedrohern

Does it have to be a macro?

If it doesn't, have a look at the reply I did for "Thunderstrai". You can use that as a stepping stone.

Regards

Ian

Re: Multiple Condition Macro

Thunderstrai

Have a look at the attached.

Regards

Ian

Re: Forumula

Andrew

Try the attached as an example.

Ian

Re: Conditional Cell Lock Unlock

iamstevie

Try the attached.

Again I could not get it to work with "true", used "ian", maybe it has got to do with it being a function.

Ian

Re: Macros For Activating Conditional Formatting Vba Code

Zadok

Don't really know what you want as there is no button on the sheet.

If you do not want Excel to calculate use

application.calculate = false

At the beginning of your code, and

application.calculate = true

At the end of your code

Ian

Re: Conditional Combobox Backcolor Change

iamstevie

Does the word have to be "true"?

I am asking because by using a differant word i.e. "ian" I have got it to work as per attached.

Maybe "true" won't work because it is a function.

Ian

Re: Code In Sub Inactive

norie, Six Strings

My deepest apologies, tried the Unload.Me and yes it didn't work.

However, changing the Unload Me to Userform2.show does work.

Thought I had it sorted, sorry.

Ian

Re: Code In Sub Inactive

Six Strings

I totally agree.

However, using the (.) between the Unload and the Me meant that the code worked. Not using the (.) meant it didn't.

Try it and see.

Best regards

Ian

Re: Code In Sub Inactive

jillyb

Have thought about this and feel pretty stupid.

Instead of

Unload Me

Use

Unload.Me

Ian

Re: Code In Sub Inactive

jillyb

I had a go at your code.

I removed the "Unload Me" part and put in "userform2.show" (as an example).

It worked, so there must be something wrong with the "Unload Me" part, don't know what though.

Ian

Re: Creating A Drop Down List

primerahomes

Try the attached, it is a way to use the combobox from the Control Toolbox.

Ian

Re: Activate Textbox On Completion Of Macro

Syntinal

Use Textbox1.SetFocus

Ian

Re: Delete Row Based On Cell Value

Benny Hays

Cell E1 does not equal anything, are we to take it that you are going to input "Delete" in that cell?

Ian

Re: Personal.xls Locked For Editing

markstro

You could open 1 file using your start up and run a macro from that file to open the second?

Ian