Search results

That's great, thank you

Hi there, I have a work book containing multiple worksheets, including 52 work sheets for each week of the year. I want to run a macro on about 26 of those worksheets. Is there a quick way of running the macro rather than going in to each work sheet and running it 26 times! How do I isolate...

Hi, I'm creating a database (using excel forms) of contracts that my organisation will assign to different contractors. For example I have proposed start date (of contract) Finish date Total duration Admin costs Staff costs I'm new to VBA, must I set out the ground rules at the very...

Can I ask you also, if I were to create this form in Access would the code be the same? Are the rules for VBA the same in Excel and Access?

Ok ok it works now, thank you very much

Ok, thanks for reply, but what is CDbl ? Would it be possible to put the code in the file and upload it back to dropbox again?

Sure, it is the Officer Form when a user inputs staff costs and then admin costs I want the admin plus staff costs field to add and fill automatically staff costs: 1000 admin costs: 500 staff plus admin: 1500 (adds and fills automatically)...

Hi, I'm creating an input form in Excel using VBA one field contains contract_admin_costs another field contains contract_staff_costs I want a third field to add contract_admin_costs and contract_staff_costs and input the answer in a third field as soon as the two other fields are input by...

Anyone?

Hi, I'm a VBA newbie. I'm creating a form which includes % values and currency values How do I insure that the user will only enter numeric values in each of these fields? 1st field must always be a % 2nd field must always be a currency amount Thanks Kevin

Anyone?

Brilliant, that works, thanks

I'm setting up a form in Excel to input information such as name and address A person's name can go on one line but an address may have several lines How can I set up my text box so that when I press the enter key in the text box it moves on to the next line within the box rather than on to...

Hi All, If I've created a macro enabled workbook, what steps must I take to insure that the macros I am creating will be available when I share the workbook on a network drive? Thank you Kevin

Thanks so Me is part of the syntax of VBA?

Hi, I am new to VB and trying to teach myself I have some questions when writing code to cancel a form we use: Private Sub cmdCancel_Click() Unload Me End Sub What does Me mean?? Also in the following code what does Me do? Private Sub cmdOK_Click() If Me.txtFirstName.Value = ""...

As easy as that, thank you

Hi All, I'm new to VBA and form design, I'm in the middle of designing a form. By default VBA has named it userform2, but I cannot find how to change the name of this form to something more meaningful, can you assist? Thanks Kevin

One hell of a formula, thank you very much works like a dream!

Hi Haseeb A what do you mean when you say assuming A1 is the data & B1 to down is occurrences entered ie: 1, 2, 3...15 ??? Thanks Kevin

Hi Narayan Thank you but I am unable to view that file, can you share it with dropbox? Kevin

Hi lhkittle yes I want the number of times a particular digit occurs in the various cells. Thanks

Hi Haseeb I tried your suggestion but it hasn't worked for me would you be able to the sample I shared, modify it and upload it? Thank you

thanks for this, but it doesn't seem to work for me, could you upload a file to demonstrate your example?

Thanks for the reply Yes splitting the data in to separate columns would be a possibility But the problem with that is you could potentially need to have 14 more columns The original file was filled in by thousands of people and now somebody has to analyse the results The sample file just...