visual

I have a simple module that calls a form to allow the user to select a row that sets a header filter and colors. I am trying to figure out how to convert this to vb.net or vb6 so it can be compiled. All the documentation I found is from 2005 visual studio and it doesn't work in visual studio...

Hello everyone, Just a quick question, if I have knowledge of VBA in Excel could i be certain to say that i know Visual Basic ...not for applications. Are they literally both the same programming language? Don't know if this makes sense lol

Hi all, It's my first time posting here, and I apologise for what will surely be a question full of incorrect vernacular and confusion. I will however be concise. So: I'm building a roster for event staff - it should be simple, but I got carried away. The first sheet (Schedule)is where start...

Hello experts, I need help with VBA code that can continuously show random photos at a certain place and picks up these photos/images that are in the same excel file.. Basically, I need 9 tiles of photos forming a rectangle and each one of this 9 tile should loop showing up random photos from...

I created a new macro the other day and it was working fine. Today when I attempted to open it, i received the error "Can't find project or library" immediately when opening the sheet. I found the support on the microsoft website indicating to: Open your database. Press ALT+F11 to switch to...

Over the years I've been seeing the subject product increasing more and more in the MS office field. As I look through the features being offered off the Banner Ad here in Mr Excel - I do not see any reference or wording with regard to Visual Basic for Applications. Can someone clue me in on...

Assalam u Alikum, Dear Team, thanks in advance for your support as usual, I am looking forward for the solution regarding card browser custom visual the problem I am facing is that when I drop the date field from my excel data in power bi SUB TITLE field its only displayed 3 cards, where ever...

Hello all, I am trying to open the VB Editor via the following macro which is associated to a button on a worksheet but I get the runtime error: 5 invalid procedure call or argument. CommandBars.ExecuteMso "Visual Basic" Using excel 2010 .. Am I doing something wrong ? or is this a known...

I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but...

Hello I have been using this form in the past and with it I have been able to produce combo boxes that are dynamic. I’d like to take the combo box to another level and allow users to scroll through the results with the arrow keys. The only problem is that the field updates to the first item...

Hi, I think this is a tricky one, it certainly is for me.... I need to display visually how well a project is running based on some date and percentage values. <tbody> START DATE TODAY DATE DUE DATE PROJECT AGE PROJECT LENGTH % EXPECTED Actual Progress Visual 1/1/17 22/08/17 31/12/17 233...

Hello All, I'm using Excel 2016, on Windows 10, and I will create my sheet and align my columns and change my fonts and everything else to look nice, and then when I email it to another computer and open it, some of the text in certain columns will get cutoff or change to ###. I'm also using...

Hi I'm working on some code in VBA in Excel 2010 and I'm running into a problem with preexisting code in the spreadsheet. My code reads in data from another workbook and posts the value in a certain cell, which works fine. However, there is code that is already there which causes an infinite...

Hi all, I have inherited this spreadsheet. On sheet 1 i can create times from B11 down eg 08:45 08:49 etc. The problem is i can have all the time stored on the data sheet but when i recall the times to show on sheet 1 it stops at cell B60. I have looked at the code and changed anything that had...

First, thank you very much for taking the time to review my question. I have been researching this topic for days, and can't seem to find the correct solution. I have been trying to figure out how to change the color of a specific tab based on information being entered in cell "B9" for each...

I am writing a Macro that essentially makes a copy of the spreadsheet I am working on, removes all the macros in the background, and then saves it to a specific folder. The entire macro works perfectly on excell 2003, but in 2007 and 2010 there is an error in the section below. Does anyone have...

Ok i have a program that goes to a different workbook and copies information. When i try to go back to the original workbook to paste the information, it says that it is out of range... can someone help me fix this? Code: Application.Goto Workbooks(Page).Sheets(Page).Range(CurrentCell) Goes...

I created a production tracking worksheet (see attachment), that breaks down everything that we want. But we need something visually that shows how far along they are while working. On their desk they have a Standard Production Job Aid (see 2nd tab) that's laminated so they can use it multiple...