Microsoft Excel

• Microsoft Excel Questions

• • I found this great little site

    I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week the...

    By ifoundthisgreatlittlesite

  • Mean of standard deviations across columns?

    Domenic,Thanks. The only issue is that the columns are not contiguous.I'm just wondering if ther...

    By modelergirl

  • remote query & date range?

    Hi,I'm using Excel 2003 to query a SQL 2000 database. The table I'm queryinghas a date field...

    By linnkubler

  • Progress Bar

    Is there any way to modify the following code so that theprogress bar will update itself according t...

    By karen

  • No change event on control toolbox combo box when ...

    Of the three combo boxes available I generally prefer the simple DataValidation drop down list. But ...

    By donwiss

• • Instert Rows Based on Cell Value

    Hello,I could really use a hand on this one.I have multiple lines of different products ordered by d...

    By derekrap, 1 Comments

  • Me.PrintForm -> landscape

    I've set up my form, filled it in, and now I want to print it.Me.PrintForm does print the form b...

    By henry, 4 Comments

  • Creating new excel docs with links

    Hello,I was wondering if I can do the below with links in excel:I want to create an application that...

    By shinra14, 2 Comments

  • Sight Unseen

    I have a worksheet in my workbook that is used as a master copy. I havea macro that creates new work...

    By oberon_black, 1 Comments

  • MSForms 2.0 Combobox problem

    I'm working on a project that runs inside Excel. When a user clicks on anexcel Cell, an MSForms ...

    By mtc75, 1 Comments

• Microsoft Excel: is the Category's subject.It's has 396 questions,this is No.20 pages.
• button
• how can i check if a button already exists in a certain sheet on opening ofa file?...
• luc, Fri, 12 Mar 2010 17:30:00 GMT, 94 bytes, 1 Answer
• Populate a ComboBox
• I used the code shown below to populate a combobox in a Word UserForm.It basically cycles through each record and loads the value of field1, 2 or 3 into the combobox depending on a user selection.Is there a way to use the combobox '.List" method to populate the listall at once vice cycling t...
• gregmaxey, Fri, 12 Mar 2010 12:14:00 GMT, 1,270 bytes, 3 Answer
• I get two copies of pictures in the loop instead of one - why?
• Hi,I have a sheet where I in Worksheet_Activate copy all chartobjects and pastethem as pictures and then hide the chartobjects. This make the users notable to ruin the references in the charts.Problem: I get two copies of pictures...why?She sheet1 had to have a couple of charts. Code:Sub CopyCha...
• mariahigh, Fri, 12 Mar 2010 02:40:00 GMT, 915 bytes, 3 Answer
• Upgrading to Office 2003
• I meant DAO will run in that version - I think that is what the originalquestion was.Regards,Tom Ogilvy"Jamie Collins" <jamiecollins@xsmail.com> wrote in messagenews:2ed66b75.0408182315.f988883@posting.google.co m...> "Tom Ogilvy" <twogilvy@msn.com> wrote ...>> Depends what...
• tomogilvy, Thurs, 11 Mar 2010 23:31:00 GMT, 788 bytes
• Dialer wont start
• The following code works fine under WindowsME but will not run in WindowsXP.The message I am getting when the code is run is "Cannot start Dialer.exe"The message has an OK option only and whae clicked will not stop the codefrom running. The only course of action is to close down Excel via the Ta...
• pat, Thurs, 11 Mar 2010 23:29:00 GMT, 865 bytes
• Outlook and Excel
• I need expert help. This code searches four lines in the body of theemail, and copies it to excel by column. I would like to add two morecolumns where the date email was received and email subject are alsoincluded.Sub bodyStrip(msg As Outlook.MailItem)Dim sBody As StringDim aFields As VariantDim...
• praetorian_prefect_2004_yahoo_com, Thurs, 11 Mar 2010 21:13:00 GMT, 839 bytes, 2 Answer
• No Blanks
• Can someone please help me to make this formula=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))not to count blanksThanks in AdvanceAnthony...
• antonyo, Thurs, 11 Mar 2010 19:40:00 GMT, 158 bytes, 5 Answer
• MSFlexGrid
• Has anyone here worked with MSFlexGrids in a macro that is to be ran onmore then one computer? I've found that i have to manually add theflex grid on each computer i put it on, does anyone have any ideas ofhow I might be able to fix it?thanks,jake...
• jake, Thurs, 11 Mar 2010 05:39:00 GMT, 283 bytes
• Populate a cell from a text box.
• Hi all,No doubt a simple question!I have a vb form into which the user types a value.Various calculations happen in the vb code which produces a string.I want to place that string into a cell on a worksheet. Does anybodyknow how to do it?Thanks!Message posted from http://www.mcse.ms/...
• unknown_user, Thurs, 11 Mar 2010 02:52:00 GMT, 394 bytes, 2 Answer
• Instert Rows Based on Cell Value
• Hello,I could really use a hand on this one.I have multiple lines of different products ordered by differentpeople. In each row in excel it shows the product that was ordered aswell as the quantity and some other information.What I need to do is expand each row based on the quantity value.Essent...
• derekrap, Wed, 10 Mar 2010 21:16:00 GMT, 1,215 bytes
• Button caption identification
• Hello!After creating 5 buttons on a sheet with form I am wrote a macro anddepending on the button I trigger a sort. What variable containg thebutton name or caption?Thank's ahead...
• bobby, Wed, 10 Mar 2010 18:43:00 GMT, 206 bytes
• Signaling the presence of a password
• Hey there,Is there a way to find out, from inside a workbook,if that workbook is password-protected or not.Why....?I have created a workbook with some specific functions inthe buttonbar that should only be available to users thathave their workbook protected by a password, if not thanthese butto...
• geertnauta, Wed, 10 Mar 2010 14:23:00 GMT, 483 bytes, 1 Answer
• Compare & Delete in Excel
• Dave,What you gave me works!I have had only one issue and it was when I had something duplicate inCol A, then it would delete all of Col B.But that is my problem, not yours.Thanks a bunch...Dave Peterson Wrote:> How about:> Option Explicit> Sub testme01()> Dim FirstRow As Long> Di...
• smittydotbat, Wed, 10 Mar 2010 09:58:00 GMT, 1,686 bytes
• Populate a column with a month end data
• Hello,I am using Excel 2002 and I am wondering if this is possible. I get a dailyreport from our main frame exporting data in Excel. What I want to do ishave a macro button that will put the month ending data on the last column.Now I may get about 200 rows of data or 300 rows of data depending u...
• alexmartinez, Wed, 10 Mar 2010 09:46:00 GMT, 610 bytes, 1 Answer
• popluating a list box without having duplicates
• I have a list box that i want to populate from an Excel list. The listwould look something like this:A BDomain A CompName1Domain A CompName2Domain A CompName3Domain A CompName4Domain B CompName5Domain B CompName6Domain C CompName7Here is the code I am using:'begin looking for new list itemsD...
• thesquirrel_gmail_com, Wed, 10 Mar 2010 08:18:00 GMT, 1,907 bytes, 2 Answer
• This application is about to initialize controls that might be uns
• If you step through the code, what is the code line that generates the msg ?"ric.payne@principa.net" wrote:> I have just started getting this message in a window called Microsoft> Forms every time I run some Excel macros. It does not happen on all of> my computers. I am writing VBA code...
• gocush, Wed, 10 Mar 2010 06:55:00 GMT, 573 bytes, 1 Answer
• mscmctl2.ocx ... calendar and date picker sometimes not available
• Scenario=======excel 2002 spreadsheet has calender control and date and time pickerfrom mscmctl2.ocx (not sure if I have correct ocx, using a hotelcomputer that can not find appropriate kb article probably becauseit is set up improperly)click the appropriate column, the date and time picker,and...
• thisisnotme_hotmail_com_nospam, Tues, 09 Mar 2010 14:09:00 GMT, 989 bytes, 1 Answer
• No calculation on new machine
• I run XP Home with Office 2002I have just installed my programs to a new machine.Excel is behaving differently on the new machine:Observed so far:i) I cannot select a cell by moving with the arrow keys.ii) I can insert a calculation, SUM for instance, into a cell and Iget a 0.00 result.iii) Form...
• robinchapple, Tues, 09 Mar 2010 04:25:00 GMT, 555 bytes, 2 Answer
• Progress Bar form window goes white
• Hi there,I am currently trying to follow the progress bar instructions from thej-walk.com website. However I am struggling to understand the reason(s)why my progress bar's form window goes white.The funny thing is that when I insert a breakpoint on the line wherethe percentage gets updated,...
• philwongnz, Mon, 08 Mar 2010 23:58:00 GMT, 975 bytes, 1 Answer
• visible code but not updatable
• Hi, Is there a way to render the code uneditable in excel. I have made my excel application and deployed to to multiple users but I don't want them to to modify the code. The app is locked with a pass. But the user can still access the VB editor and change that code. I am looking for a way...
• alexxx12, Mon, 08 Mar 2010 23:18:00 GMT, 537 bytes, 1 Answer
• «««1011121314151617181920