Registration date
August 7, 2010
Last seen
August 31, 2010
Contributions
29

Dropdown lists in excel 2007 [Solved]

Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blending), if I select say Mill then in cell2,2 a dropdown list with all the mill parts must appear, same for the other if I select one of the other names their parts list must appear.Can anyone ... Read more

How to make a seril number continue [Solved]

Hello, I was wondering if you could make a serial number continue.. What i mean is.....lets say that i have to continue a serial number i cell F5 and i need it to automatically update to the next number (e.g.100 next time i open the sheet i need it to be 101)... any help would make my life a little easier thanks......... Config... Read more

Getting the week number automatically [Solved]

Hi,.. I need to get the week number automaticlly.. Lets say I enter the a date in Cell A2 then i want Cell B5 to show the respective week number. Lets say for example if today is 18/8/2010 and week should be 33 i recorded a macro and entered it into sheet1 code but nothing happened.. can some one help me correct this code.. thanks........ Read more

How to make a user form appear when a workb [Solved]

Hello,.... I need a user form to appear when i open a workbook.. I dont want to run it in macro need it to automatically appear once the workbook is opened. Thanks...

Combining 2 VBA codes [Solved]

Hi.. I need to combine 2 codes together. I'm very new to VBA. These are the 2 codes I need to combine. when I paste the 2nd code it doesnt work properly Code1 Private Sub Worksheet_Change(ByVal Target As Range) 'Erik Van Geit 'only allow PasteValues If Application.CutCopyMode = False Then Exit Sub With Application ... Read more