setting

Hi Everyone, I know how to change the audio volume level setting using VBA by sending the VK_VOLUME_UP and VK_VOLUME_DOWN codes to the virtual keyboard, but my code also needs to know what the actual level is. I've been trying to persuade The Google to tell me but haven't even got as far as...

Dear all, I have made a vba macro code to get date from Excel cells in a special format to be used for follow up. ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""ÅÅÅÅ-MM-DD"")" ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""YYYY-MM-DD"")" In Sweden, Windows regional date format is ÅÅÅÅ-MM-DD. The letter Å...

Hi All, I am getting publish error (.Publish (True))in below code in Clinet enviornment, However it working fine on my system. Even if i am trying to creating a HTML page manually, it is showing as "Page can't be displayed". Can anyone suggest here what setting needs to change for fix this...

Hi, The following works fine (I'm currently using Userform1 with vbModeless) Userform1.Textbox1.Value = Target I just want to know what affect this has when the Userform hasn't been loaded. It seems nothing happens but is it using memory? Or a bad idea? Can I check whether the Userform is...

Hi, So the title of this thread is probably not the most helpful but I could not come up with anything better - suggestions are welcome. I have a formula like this: =IF(SUM(E9+H9+K9<=8),8,SUM(E9+H9+K9)) which basically says if the sum of the values in cells E9, H9 and K9 are less than 8 then...

Hello I made a pivot table add to the data model of the query Connection. There is no use custom list when sort in my slicer setting and I have encountered sorting problems. thank you for any help you might provide

Why do some worksheets request permission to enable macros whereas others don't? I can't seem to find any consistency, so must be missing a basic setting. Thanks!

Through intellisense, I cannot find the backcolor fill setting for a checkbox shape within an Excel spreadsheet. I've used the "With" statement to make sure I'm selecting the one-and-only checkbox on the spreadsheet as well as the entire workbook. I'm not sure why this doesn't work? With...

Using Excel 2010 Sometimes, when I have it set to Find By Columns, it will only Find By Rows. Any idea why? Toggling the setting doesn't help. Maybe closing and re-opening the xls? I don't think that worked.

Hi Guys, I have office 365 insider. My question is that for Power Pivot the keyboard shortcut should be Alt + B + M. Instead I have to use Alt + Y4+ M. is there a setting I should do?? can I change the Keyboard Shortcut?? For me it is 1 key extra. Thanks for your help.

Hello, May i seek help for the formula I can use to make a list of activities from the given calendar setting? https://www.dropbox.com/s/tgzz9815ma95cdq/making%20list%20from%20calendar.jpg?dl=0

Width is set to 45 and col names are centered. Somehow I've managed another effect which I can't repeat. The names are vertically aligned so they're about 1/16 of an inch above the bottom of the cell. Not bottom, centered, or any other setting offered by the Alignment tab (Format Cells). Any...

I have two cells F6 is a number value, L6 is text either "Personal" or "Public" I need to out put either "Very minor" "minor" "Serious" "Major" based on the values of F6 and L6 First part i tested is below but i cannot get any further as got stuck on addition checking of values in F6 and L6 and...

Hello all This line of code is part of a larger piece for emailing out a group email with an attached workbook which works fine. The range is column "C" to Column "Z" It filters on column "W" (Field 21) and the criteria is "Out" I need to add an additional filter on this if possible In...

My border won't appear. What setting do I need to change to get a border appearing?

Hi there, I need a VBA code to check for the date in the AI4:AI9999 and to move the entire row of oldest date right to the top, ideally setting it all up in the order from the Oldest to the Newest date. All my data is in C4 to AQ9999, Any ideas? Thanks

Hi All and HNY2019 Is there simpler and cleaner way to code this to make the Status Bar appear to flash? Sub StatusFlash() Do Until c > 5 Application.StatusBar = "Setting up - " Application.Wait (Now + TimeValue("00:00:1")) Application.StatusBar = "Setting up -...

Hi I'm doing a summary table for the data that I have. See sample below. I was just wondering if there's a way to make the dates change automatically depending on the selected setting (first box) without having to make a really long if statement. For example, the setting now is for September...

Hi, I cannot for the life of me figure out what I need to do to stop this from happening. I am working to edit some VBA that a colleague has created. There is a simple error in a line where the current text is .row 1 This needs to be +1, but everytime I type +1, it autocorrects it to the...

For some reason on the Layout and Format tab, under the Layout option, the "Merge and center cells with labels" is checked when I first create a new pivot table (it seems to be a default setting). I looked in the backstage options on the Data tab (I'm running 365 on my computer) but I don't...