tips

  1. S

    How enable extended tips for own macro button

    I have assigned a macro to a button on my menu, but I can't find a solution to write and show extended tips. When the mouse arrow is placed over the buttong, only the same name as the buttong is coming up as tip. Have anyone any experience with this...
  2. J

    Convert numeric to text

    I have a value in a5 (82700000) Needing it to display in a6 as text 82.7 Million. Could also be 827000000, needs to be displayed as text 8.27 Billion I know it has to do with Len Just cant get there, Any tips or solutions are greatly appreciated. Jack
  3. A

    Copy/Paste to Add Sum of Cells Across Separate Workbooks

    I have a master worksheet which is generated automatically at the end of the week by our system, which logs tips and mileage collected by each employee. We have deliveries which take place outside of our system which also need to be recorded, but cannot be logged by the system, so they need to...
  4. S

    Subroutine Processing Visuals

    I've just finished creating my VBA spreadsheet and while it's very useful and 'a bit of a beast' it's not so impressive to look at while running. I played around with turning screenupdating on and off and either way doesn't make much difference so was just wondering if anyone had any tips on...
  5. A

    Developmental/Intellectual Disability - Can anyone relate?

    Hi, I'm AnyaK and as I often mention on my posts on the board for Excel questions/help, I am autistic with multiple specific learning difficulties (ADHD, Dyslexia etc.). I also have visual processing issues, anxiety disorder...well, you get the idea. I was wondering if anyone could relate to...
  6. F

    Is there an easy way to sort feet and inches?

    I'm trying to figure out how to easily sort feet and inches. Let's say I have a column with only feet.. IE: 34' 355' 154' 1503' 14' 6" 10' 7" 50' How could I sort this? I want to go greatest to least, and least to greatest. However, I'm having a hard time figuring this one out.. :( Any...
  7. B

    Increase Efficencey

    broad question but i have a report that ends up being close to 26KB and it takes way to long to open and function. most of the report is based off SUMIF statements, stuff like that any resources, tips anyone has i can use/check to try and make more efficient and shrink the size so the user can...
  8. B

    Tips before starting - how to display several data of one owner?

    I have pretty much only done one larger build with access. Now im starting to preper to redo everything, build it from scratch and make it a bit better from all the stuff i´ve learned so far. But before i start id like some tips on how to design the tables best. Currently i have quite large...
  9. B

    1 hour video on Excel tips & tricks

    https://www.youtube.com/watch?v=u3HKXOKzYzA
  10. S

    VBA Code Not Looping Through Every Tab

    Have about ~100 tabs here ... This code seems to only work on one sheet at a time. Any tips? Thanks! Sub CopyNameCelltoSpecificSpot() Dim ws As Worksheet Application.ScreenUpdating = False For Each ws In ActiveWorkbook.Worksheets Range("A5").Copy Range("A46") Next End Sub
  11. G

    Tips, Macros, Loops to begin Excel Consulting service as VBA beginner

    Hi I’ve used excel a lot throughout undergrad and graduateschool but never knew about VBA until after graduating. I used a lot of powerpivot and VLOOKUPS during an internship. Also, I use excel quite a bit in myengineering position and started taking courses online to learn VBA. My dad hasa...
  12. B

    Excel Budget Planning Tips Please

    Hello, I am new to Excel and trying to make a budget planner. I have already created a basic sheet for the entire current month, a second sheet for Payday, and a third sheet for the following month. I have learned a lot of what not to do LOL :laugh:. Any tips or pointers out there to enhance or...
  13. V

    Adding Tips in a UserForm

    Hello, I am creating a UserForm to collect data in a spreadsheet and I want to add balloon tips to the form that appear when the the mouse pointer is over the field. Similar to how comments work in a worksheet. This is to give the user more info as to what is expected in each field. Is anything...
  14. T

    Easy...Simple....Can't figure it out

    Have this: A1=val A2=val A3=val A4=val A5=val A6=val A7=val A8=val Need to turn next column into this: B1=A1 B2=A1 B3=A2 B4=A2 B5=A3 B6=A3 Excel won't pick up on the pattern, any tips? Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or...
  15. C

    How to track user issue feedback

    Hey all Hopefully someone has got a good way of doing this that is somewhat automated or at least 'less' manual. In my company we keep and Issue Log of various issues. For example see below something like what we have. <tbody> ID Raised By Category Issue Details Reviewer Response Status...
  16. D

    VBA name new series based on variable

    Hello, I'd like to add series to a chart on a new sheet. The name and range is based on r, however the range works fine, but the name gives an error. I tried setting the name as a Range variable and as string as well, but no luck so far... Any tips? For r = 1 To 8 .SeriesCollection.NewSeries...
  17. T

    Formatting Question +0

    Hi I have assigned the following formatting (+0;-0.0;0) to display all minus values as -0.0 and all positive as +0.0 but my zero calculations are displaying as +0 which is upsetting my conditional formatting. Any tips for formatting type to display all Zero without the + sign in front Thanks Stephen
  18. D

    General Macro Speed Question

    I'm stumped on some code I'm running. I have two workbooks that are for all intents and purposes identical. I have a macro I am running in both of them that has identical code. In one workbook it takes six seconds, in the other 1 minute and 20 seconds. Does anyone have any general tips or...
  19. N

    Disable Function Tips in Excel 2010

    Hello all, Quite a trivial question but I was wondering if anyone knows how to disable Excel's function tips, which pop up underneath the function bar? They cover over some column headers. I know they can be dragged around the screen but this gets very tedious and annoying when typing lots of...
  20. L

    Quick question re: Labeling Data Points in ScatterPlot

    So I'm almost there. I'm using some stuff I found from Andrew Poulsom to add labels to a scatterplot based on the Ch_MouseDown event. The issue that I'm having is changing the reference in the text to a different cell. Basically I want to pull back the UserID # which is in column B. So...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top