bar

I have a form with a header section (containing controls) and the detail section which returns the result of a Search - determined by what is input in the control(s). If I have the vertical scroll bar showing, it extends into both the header and the detail part of the form. Since the...

I have one workbook that has a Workbook_Resize event macro in its ThisWorkbook module. The workbook has an AutoOpen macro that among other things sets a public/global variable - Filename - to the value of ThisWorkbook(). E.g. File.xlsm. As a matter of procedure and knowing that my macros...

Hi all, I have failed in trying to find this information via searches on this forum and Google so here are my questions. Using VBA MS Office 2011 for Mac: Can you hide the title bar? Is it possible to get a picture to be inserted into a userform? No matter what size or format I try I keep...

I have clustered bar chart. I have one array of values where the values can go from -5 to 5. The y-axis is a 0 which is good but the y-axis labels are also in the 0 range.Since the axis value is positive or negative, some bars actually overwrite that y-axis labels. If I move the axis to one...

Good rainy afternoon. Perfect time for doing computer stuff. :) I export, in to excel, reports from a database. In one of my columns, (start time), the cell value displays as 0001 However, what shows in the formula bar, for that same cell, is: 7/12/2019 12:01:00 AM How do I get rid of the...

Hi; I did see this question asked before, but I couldn't find a thread with a posted answer. I'm mostly frustrated because I'm 90% sure it's a stupid simple fix, but I can't seem to get it... I'm trying to copy a graph format from previous reports so that it's consistent. I've got a stacked...

Hello, Anytime a save a file that has bar codes in MS Word. The file converts bar codes in to human readable text. Any idea why is it doing this and how to stop this behavior? Regards, Rajesh

Can I create a comment template with a scroll bar using VBA which gets trigger through a command button

Good day all, I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 columns. The 40 textboxes on the first column each have a list box. The problem is when I double click on the list box...

Hello The below code somehow overwrites the formula typed in rangeE1 What i am trying to do is that if i check value as formula then the txtValue should display the Formula if unchecked then it should display the value in textbox this is like Formula Bar and Cell Value. Second thing if i type...

Is this even possible vba code :- pressing space bar to navigate sheet tabs? Selects and displays next sheet each press

Hi everyone, I'd like a macro that resets the vba scroll bar to the top, I mean the actual bar in the scroll bar, I can do it manually within the properties under value but can't get the vba to set it. can this be done? Thanks Tony

Hi everyone, not sure if this can be done but what I need is this. I have a sheet with 800 rows I have a scroll bar and I need to move it to the right position on the page. so I need a macro that can count 100 rows from the top and move the scroll bar so the top of the bar is in row 100...

Hi Everyone, I want to set up a VBa scroll bar to move a value up and down rows in a column? In Column Y I have the word "Start" now lets say its in cell Y25 I'd like to have a VBA scroll bar next to it and as I scroll up and down have the word "Start" move up and down the Column. can this be...

Hi community, I need help creating the chart that shows how much time of the day a room has been used/been idle. Sort of look like a bar code. How do i create that? I have data of the time the procedure starts and its duration. <colgroup><col><col span="2"></colgroup><tbody> ID Start time...

I have a bunch of bar charts that need to be updated monthly or quarterly. I would like a quick easy way to update all of the charts when new data is added automatically. The far right bar needs to be an orange color as it is not a complete amount for the time frame. An example would be we...

I have a progress bar which is based on a loop code. what I need is some code that will run the progress bar based on a time value located in a cell. The macro I am running is a mixture of copying & pasting from one sheet to another, running filters, deleting data and re-sorting. I have no...

Hi! I've been trying to look for a way to "merge" two or more bar charts, with no success over google nor MrExcel. I'm trying to merge two bar charts into one.As said, one image > 1.000 words, here's an image of what i want: https://ibb.co/bBkdDFf Creating 3 series and making a stacked bar...

I am trying to send a progress message from a custom VBA function - I get no errors, just never see the messages on the status bar. I have stepped through the function and confirmed the display command is executing. I can run a SUB from this same workbook/module and see the status bar updated...

Hi all Excellers, I have a very simple question but may be a bit of a challenge. I made a data bar in the conditional formatting under Styles. The rule type used is "Format all cells based on their values" The resulting bar comes up based on the value of the cell and the minimum number and a...