Search results

Hi there, any one out there created a World Cup 2014 score tracker to use for an office sweepstakes? Thanks Kevin

Hi there, I've used this post by Hui: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/ to create my own word docs from Excel. But how do I set up the macro so that at the end the desired word document opens rather than just sits in the folder? Thanks Kevin

Hi there, I've used this post by Hui: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/ to create my own word docs from Excel. But how do I set up the macro so that at the end the desired word document opens rather than just sits in the folder? Thanks Kevin

Hello, I have a workbook with 53 work sheets in it. 52 of these work sheets are hours worked and leave days taken for every week of the year. The 53rd sheet calculates the amount of days worked, leave days, sick days etc over the year by using...

Hi there could anyone help me with writing some simple code? All I want to do is run an input box which will take in a string and rename the active worksheet with that string

HI there, I use Hui's VBA macro to generate a word document in a specific folder (http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/) But what if I want to email the word doc rather than save it to a folder? How do I go about that? Thanks Kevin

Hi there, I've got a named range, a list of employees, it includes their title, name, address, employee number, contract start and contract finish date. It contains say 52 employees. I've named my list Emp_list But if I add a new employee to my list (number 53), how do I insure that they are...

Hi, If I send a workbook containing a macro, it will not work on the recipients machine. How do I set up my workbook so that when I send it the macros will work on the recipient's computer?

Hello, how do I create a macro which will add the current worksheet I have open to a new email as an attachment? The to field in outlook can be blank. Any assistance greatly appreciated. Thank you

Hello, I've created a spreadsheet where I want certain cells to be password protected and non modifiable, simple, you would think. Unlock what you want to be able to modify and click protect sheet. However there is one entire column which I have verified as locked, that simply will not lock no...

Hi, I'm trying to create a league for a tennis competition. There are 12 players, each player plays one different player every week. So 11 games over 11 weeks. Does anyone have a macro that can look at a list of 12 players and produce 11 lists where each player plays everyone else once? Thank you!

Hi, how can massive numbers be displayed in Excel? question broken down 29^289 = 7.2215E+413 now get the modulus of that huge number by 33 so mod 33 of 7.2215E+413 should = 8 but excel cant do it numbers max out at 109E+105 or somethinng like that See this file for a better...

Hi, I've a spread sheet which is meant to calculate the amount of overtime hours an employee has worked up over a year. The formula works fine until overtime hours worked exceeds 24 hours. For example: current overtime hours are: 22:00 Employee works another: 03:00 excel reverts to 24 hours...

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...

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...

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

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

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 = ""...

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

Hi, A friend of mine has passed on a problem to me He has a massive survey spreadsheet, one of the questions people responded to was: What is the reason for hospital closure? There are 15 possible answers, numbered 1 to 15 So users typed in 1 for the answer But there may have been more...

Hi, can anyone point me in the direction of a tutorial on creating forms for data entry in excel. I've a spreadsheet where I want to insert a button called "new entry" clicking on "new entry" will open a form and from there I want the user to enter data and click submit. After that the...

Hi, I see that in Excel it is quite simple to design a form using column headings, but what if my table is more practical with row headings? I am attempting to create a simple database in Excel, can I design a form using the ROW headings?

Hi, I am a member of a tennis club. We are looking at creating a very simple tennis court booking system. Members will arrive in to the club sign in to the tennis club computer and sign in to a court. There are 9 courts. All games begin on the half hour or hour and courts must be vacated...