interactive

  1. A

    Enable interactive calculations

    I have enabled Interactive calculations in Option/Formulas. I have PW protected the Workbook and the sheet. Others use the form to input data. The enabled Interactive calculations keeps coming unchecked or going back to what is default. How do I stop this from happening?
  2. L

    interactive userform (read/write)

    Hi I want to learn how to make simple interactive form like the one below which can upload data from excel sheet to the form if user entered an existing ID# or if the ID is not existed then that would be a new record to be added to the form. ExcelEasy website has the code but I have found it...
  3. M

    Drag and dropping the controls in a User form at run time!

    Hello, I want to develop a user form in which user be able to drag and drops the controls (Labels or Text boxes) from one specific frame to another frame. Can anybody helps me on this? Is this possible in VBA excel and is this handy? the actual project is bigger and have the login and log...
  4. H

    Interactive Calendar with sheet for each day?

    Probably a long shot. I haven't created anything yet was just interested if this was possible. I would like a calendar, full year on single sheet. I would like to be able to click a date in the calendar for example click 23rd May and have a sheet open in which i would store business results...
  5. F

    Interactive charting with filters

    Hi guys, new to the site so let me know if I'm doing anything wrong and I'll improve! So I have a large chart of data with tens of thousands of cells. My task is to create a tool that will create a dynamic and interactive column chart that is linked to either drop down boxes or a search bar...
  6. N

    Create a macro that will access a website and pull specific data

    Hey community! I have a complicated project and needed input/ information as to how to create a macro to solve this. I need to create a macro that will access a website (with a username and password) and search for specific information. I will have a list of PO's. I need to macro to input...
  7. D

    Interactive comments box

    Hi, I have created a sales dashboard for some product managers. At the top are 2 drop down boxes (the 2nd being dependent on the first, thanks to another thread on here! :biggrin:) whereby the user can select the manager and then select one of the product categories for which that manager is...
  8. A

    Make bars on bar graph change color if limit passed

    Is there any type of Macro or way in excel that can make a single bar on a bar graph change colors if it is passed a certain limit. Right now my bar graph has data that is automatically updated every 10 minutes. Can we get it for a bar to change colors when a value in the range of where it is...
  9. A

    InterActive Line graph help

    I would like to know if there is a way to highlight my line graph when the line passes the control limit. Also If there is anyway to highlight the line when I hover over it and show a lot more detail, that would be very cool. I have been looking around for a video or blog that would show me...
  10. T

    Interactive Pivot Calendar with Tasks

    I have an interactive pivot calendar built in excel with the ability to click to change the months and the year. It is very similar to the following link...Interactive Pivot Table Calendar & Chart in Excel! | Chandoo.org - Learn Microsoft Excel Online. What I need to do is have a list of tasks...
  11. K

    How to create mouse-interactive ChartObject?

    Hello, I have created some charts (probability distribution models) as embedded ChartObjects on a worksheet with VBA, and would like to enable events so that I can click and drag the mouse over the chart(s) to change the parameters of the distribution model... How do I enable events for...
  12. adaytay

    Interactive Excel Chart

    Hi all, it's been a while! Had an unusual request in from a client, and thought I'd post up here as it's something I don't even know if is possible. A client has a spreadsheet with a table of data and a chart. Updating two cells with new latitude and longitude co-ords moves the position of an...
  13. R

    Changinf cell values by moving chart data points

    I have a line chart with markers, i would like to be able to move the markers and change the cell values they refer to. I googled it and found something on this board :Moving a line chart data point revises data table value in Excel ' - ExcelBanter They said the functionality did exist but was...
  14. J

    Dynamic area chart using IF statement

    I'm having trouble drawing an area chart that ends sharply at a specifided value rather than drawing a diagonal line down to zero. Let me explain I watched an Excellsfun youtube tutorial that used the IF statement to chart a subset of normal curve data as the second series in an area chart...
  15. F

    List system, need VBA code assistans

    Hi, I'm working on a data sheet/equipment list system for my business and need VBA code to minimize the filesize. For now i have two separate things i need help with: 1. I use a Table with 38 Columns to input my data. I want to have a button that adds a row to the bottom of the column with the...
  16. L

    Chart Question - Please help

    Hi, I am really struggling trying to figure this one out and am hoping that one of you guru's can assist me :( I have 4 columns of data, A = Title of issue, B = Volume, (Bar Chart) C = Cumulative % over total, (Line Chart) D = Description. I have created a Pareto Chart, Title (Column A)...
  17. M

    interactive validation lists?

    Is it possible to make two validation lists interact with eachother? Example: A1 = "cat", A2 = "dog", A3 = "bird", A4 = "frog", A5 = "fish" B1 = "Code 14", B2 = "Code 47", B3 = "Code 21", B4 = "Code 34", B5 = "Code 56" Range A1:A5 has been named "the_animals". Range B1:B5 has been named...
  18. J

    Interactive Dashboard... Publish to Web?

    I have developed an interactive dashboard type workbook for my company... but I would like to be able to publish it on our intranet instead of re-mailing out a workbook every week. How can I publish my dashboard to the web and maintain interactivity? I tried going to a workstation with Excel97...
  19. M

    Can this be done?

    Hi, I was wondering if I could use excel for making a map at work? We don't have any other mapping programs and I thought that maybe I could use excel to complete this. We have a lot of Trailers (mobile homes, campers, etc.) on our yard and they are sorted out all over the place. People make...
  20. O

    interactive drop down list

    Problem: how to create an interactive drop down list Version: Office 2007 I have been working quite some time on making an excel sheet and gone through quite a lot of tutorials. If this is already posted can you can please refer me to the original post. I have been working on a summary excel...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top