Answer Questions

• Devan47 Writing result in Excel

  Hello, I have the folowing code:   Public Function DgrMinSec2DecDgr(Angle As Double) As Double ' * -------------------------------------------------------- ' * Program not yet working ' * -------------------------------------------------------- ' * Variables Dim grd As Integer Dim min As Integer Dim sec As Integer Dim calc As Double ' * Values grd = Angle \ 1 calc = (Angle - grd) * 100 min = calc \ 1 calc = (calc - min) * 100 sec = calc \ 1 DgrMinSec2DecDgr = grd + (min / 60) + (sec / 3600) DgrMinSec2DecDgr = Round(DgrMinSec2DecDgr, 4) ' should I round this result ' * Write - problem in writing in cell 'Debug.Print Round(DgrMinSec2DecDgr, 4) 'ActiveCell.Formula = "Write" & DgrMinSec2DecDgr ActiveCell.Sel ...Show All

• Javahar Comparing and filtering data in Excel?

  I’ve been given the task of comparing two sets of employee data, both of which are in the same layout/format, and am required to filter out those which are duplicates i.e. should leave only new starts. I have been told that a Vlookup function can be used to achieve this but don’t know how it can Would this be easier to accomplish using VBA If yes, could I have a brief structure of the code required To elaborate, the spreadsheet contains a unique employee ID and other details such as department, manger, email, etc. One set of data is from the previous months upload and the other is the latest data pull. I need to compare this months data with last months and see who is present that wasn’t before. Any help is much appr ...Show All

• swathi_challa excel macro

  hi, i have a worksheet with different employees and their manhours. employees may vary daily. i want to compare all the employees performance and then draw a graph. please help me to solve this. thank you Hi You would be best using a pivot table to look/analyse the data. If you want to make the pivot table or chart into a macro i would suggest recording a macro while creating the pivot then opening it in the VB Editior and tweaking the code there. I find this is the best way for learning how to code in Excel as it creates the bulk of the code to start you of. If you're stuck or have any problems post back as people are very helpful on here. :) ...Show All

• 95five0 Dimensions in BSM

  Hi We are building a scorecard to report the sales. We need the rows to display the time, ie., by year, quarter and month. And the columns to display the autaul sales and its target values for a particular time dimension.My datasource is SSAS cubes. Is there a way by which I get the Actual and the target value for a year and by drilling it will I get the values for a quarter for a particular year, and by drilling through the particular quarter, will I get the values for the month of that particular year and quarter.I get all the values in the format that I wanted in my cube. Can I achieve the same using Business scorecard. I have created 3 KPI's. One for year, one for Quarter and another for Month. After adding them to my scorecard a ...Show All

• Raihan Iqbal Moving Data

  I'm trying to figure out how to write a code in excel to do this I have a list of data like this: a 12345 name address ect. b 12345 name address ect. c 12345 name address ect. d 12345 name address ect. e 12345 name address ect. What I want to do is to move the data perpendiculare like this: a 12345 name address ect. name address ect. name address ect. I also need it to cut off the letter and the account number when it is moved and it always needs to move the corresponding data to the same location. If there isnt a b record then the spot where b record would have been would be blank. Each account will only have upto 5 records a-e. I am not a programmer so I dont know if this can be don or not. But since I have alot o ...Show All

• incendy use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All

• Scythen How do you create a flashing cell

  I have been trying to use macros, very little success. My first macro question is how do you get it to run besides using F5 everytime I am also trying to create a flashing cell when there has been any text entered into that cell Please any help is greatly appreciated. Cool, I appreciate the help. i'm not quite sure if one can make a flashing cell, but if what you want is to highlight (by changing color of txt or background) the cell when certain text is entered, try using Conditional Formatting. Format --> Conditional Formatting ...Show All

• TimothyForde001 dtpicker MicrosoftWord Template

  Hello, I am new to VB, but have general understanding of other programming languages. I am trying to create a Microsoft Word Templete document which incorporates the dtpicker control. I would like the users to be able to select the date they made changes to the form. This form will be passed via email from rep to rep until all data is collected. Problem: 1 - when a document is created from the templete and saved; Upon openning the document at a later date the date picker does not hold the value of the last date selected. 2 I tried using text box along with the date picker and some code behind to assign the value of the date picker to a text box upon date changed. Problem when this document is passed over email this functiona ...Show All

• FugersonHall Normal.dot file for word 2003 or version 11.0

  Having installed MS Office 2003 professional I have found that the normal.dot file has not been created in the C:\Documents and Settings\(username)\application data\microsoft\templates ..... I have conducted a search of the computer (including hidden file) to no avail. How does one create this file Any assistance would be most appreciated. Thank you for your reply to my query, however, I have discovered that no matter how many times I rename or delete the normal.dot file it seems that word is not creating a new normal.dot file. I have had to copy a normal.dot file from another computer, however, any changes to the toolbar, paper setup etc. is not retained or written to the normal.dot file. ...Show All

• ANS-Denver How do I call for all installed printers....

  Hey, How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox Best Regards Cathrine Hey, Thanks for your replies. Excel 2003. If VBA only have the ActivePrinter solution, is there a API call I can use Cath I don't think it is possible to find out all installed printers:(. You can get only the active printer using Application.ActivePrinter property. To add items to a ListBox in Excel, you do something like this: Sub addlistbox() Dim lb As ListBox Set lb = Sheet1.ListBoxes.Add(10, 10, 100, 100) lb.AddItem (Application.ActivePrinter) lb.AddItem ("mo ...Show All

• arkiboys Projects, objects & modules

  I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Thibaud Find Method - enter value on one worksheet and search in another

  I'm a newbie trying to set-up an Invoice form on Excel -- my set up is: A combo box for selection of Customers cboCustomer RowSource=AddRange (in worksheet Add) ControlSource=Customer (in worksheet Job) Now I need to find whatever value/string returned to Worksheets("Job").Range("Customer") in Worksheet("Add").Range("AddRange"). So I can copy the 3 cells beside that value/string. (Initially I thought this could be accomplished in combo box alone but turns out it doesn't support multicolumn...) I am also having problem with the Find Method because most examples I seen it only works with pre-determined value I've spent the past few hours trying to figure this out... Any help is grea ...Show All

• Sniper167 VBA script not accessing another workbook

  I have written a simple application for user that pulls information from another workbook. When my workbook is open, the source worksheet cannot be accessed, but when I shut my workbook down, the source workbook can be accessed. This was written using office 2003 but was saved in a 97 to 2003 format and the user is using windows xp. This is happening on the user's computer but not on my own which is on the same network. Could security on the program cause an issue due to macros Derek, there could be several reasons you're experiencing technical difficulties. Too clear things up, could you post the VBA Code here for analysation. Thanks, halfazner =] Sub populate() 'total reps in team a at ...Show All

• Samer Selo MS Access User Defined Permissions

  Hi there - im building a contact management system and require some help with coding. I have a table (tblusers) for users that contains their information e.g. user name , password and tick boxes that will hopefully allow them to edit certain levels within the hierarchy of the system e.g 'allowcompanyedit' tick box will allow users with that box ticked to create and edit company information, 'allowcontactedit' tickbox will allow users with that bx ticked to create and edit contact information etc etc. I have created a user login screen and added code to a command button that checks their credentials against what is held in the users table to see if they should be allowed to log in or not. I would like to add additional code that will also ...Show All

• Yazan R. DLookup help?

  Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All