learn

Hey all, new here and excited to ask questions and learn. I was searching the net and all and couldn't find any specific answer to the question as the title implies. So far I was able to learn, that if you want scrollable text in specific cell, I need to use under the Active-X section, choose...

I posted this a week or so ago and someone replied that I had to add a download to it, I am not sure if this acceptable but : https://drive.google.com/open?id=1t-...JjSeS9EgyIvuKA This is a representation of a MUCH larger workbook I just wanted to give the idea. I would be ever so...

I apologize in advance. I am not an expert user and I don't want someone to do it for me just tell me what I need to learn to do. Ok here goes. I currently work in a workbook with 99 sheets. Each sheet represents a machine on a line or the "total for the day" sheet for each line (there are 6...

Hi I want to learn how to clean excel file from all none wanted characters. So I want to type these characters first and then learn how to use formulas etc to remove them. I want to know how to type these none printable characters in excel. I read the article below, it says that char(127) but...

Hi All, I am trying to teach myself VBA. I have created some examples that I am trying to solve but I have no actual need to complete these tasks (other than to learn the code itself). With that said, what I am trying to do in this example is create a macro that inserts a spin button in each...

Hey Guys, do any of you know how to import into Peoplesoft from a flat file? From what I understand its an excel file converted into a txt file. I am trying to learn how to do this and the internet doesnt have anything that can help me. Thanks, Jordan

Hi All, very very new to power Bi. Can you guys help me from where I can learn easily power bi..

Hey everyone, I am new to VBA and all related parts of it. So I am trying to code some of my looped works in the meantime and I am eager to learn. But now, I can just edit the related codes that I can find here, these editions are just limited with references or sources or paths or spelling...

Hello, all. I'm entirely new to the VBA language, and currently in a situation where I don't necessarily have time to learn it (Overseas with USMIL). I have a spreadsheet which conducts several calculations across multiple sheets, ultimately boiling down the results to a range of 4 cells. I'm...

Hi My name is Husayn i am new to MS Access, want to learn access suggest site or some videos which can help me to learn Access step by step. Regards Husayn.

Whats the fastest and best way to learn VBA?

I have a Roku, an iPad and an iPhone and I am subscribed to the Bill Jelen channel. While I am very familiar with Excel, I want to start at the first one and go through each one. When I look at the list of videos many are not in order. For example, the first one I see is 2188 and then 2187...

Hi Everyone, I am fairly new to VBA after recently undertaking (well, still going) an online VBA course. I've used this forum a lot to learn different code, as although the course is fantastic for building foundations, as you all know, it takes a lot more practice than just a short course to...

Hi All So, I have dates in column A and dates in column C. I need C to be cleared in the event A is changed. I also need this to work all rows. I have been trying for a few days copying other solutions that look close and jave been trying to learn aswell but I need this quicker than I appear...

I have read that keeping formula's in VBA is alot quicker than, VBA putting the formula into a spreadsheet and the calulation being done from there. I am Keen to learn how to do this , I have a spreadsheet that takes about 2 minutes to update so i want to start looking at ways to speed this...

Hi , i am working as MIS spock n now learning to create macros and learn some new but issue is when i am trying prepared new macros but it is not runing

Hi all, I don't understand macro at all but I want to learn it. Can you pls let me know the easiest way to learn macro online? Thanks for the help in advance. Regards, Harshad

I have 6 numbers and a letter (1, 2, 3, 4, 5, 6, X) that I need to list in every possible 4 digit combination that includes duplicates (i.e. 1111). Is this possible to do in Excel instead of having to manually type every one? I have seen a couple things online but it deals with Macro's, which...

Hi all: First, and I am sure i speak for a lot of us here, that the experts time plus insights into VBA are very helpful. On another topic, does anyone have any recommendation to learn "practical" vba. I don't post too often as I am not trying to get free code and would rather take the time...

Hey all, I'd just thought I'd chime in with my opinion after reading and attempting to help some posters over the last few days. I've been on the board here and there in the past asking questions on things I havent been able to find on Google related to VBA mainly. My opinion, from what I've...