loaded

So I developed a few problems with datepicker in excel currently then I have to do more reading about that object.What I found was that it does not work well on the 64 bits office versions.When I tried testing it on 64 bits office version, it said it couldn't load the object. Then when I went to...

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, I have a listbox (listbox1) with the numbers 1-52 in it. I would like a code that highlights the current week when the userform is loaded. Any help would be much appreciated. Thanks Dan

Hi guys! Taking my first steps in working with arrays. I'm trying to load a dynamic array as an autofilter criteria, but I must be missing something. Found some hints Googling around, but couldn't make it work. I will get the filter marker in the right column, but no filtering results. Array is...

How can i rename an item in a listbox that is already loaded on a userform with a textbox value?

I'm using Microsoft Excel 2010 and had a few useful add-ins like flex find installed. https://www.jkp-ads.com/officemarketplaceff-en.asp.However, I do not use these add-ins frequently. Since it seems that Microsoft excel 2010 loads, these add-ins at start-up and it significantly increases the...

The goal for this query is to achieve the yard report at any time I run the query. To clarify when I run this query I want to know: what the trailers status loaded/empty/other currently in the yard. I don't need any information on the trailers that are out of the yard. The status must change if...

Hello I've button which loads Userform2. In Second command button i want to know whether userform2 is loaded in Gen Module Public usrForm As Object Function IsUserFormLoaded(ByVal usfrName As String) As Boolean IsUserFormLoaded = False For Each usrForm In VBA.UserForms If...

A userform is loaded when a certain condition is met. When the same condition is met again, an instance of the same userform is loaded. What I need, is to add a timer after loading every userform to unload automatically after x seconds, so after x seconds this specific instance is unloaded...

Hi I am just getting to use Power Query. Is there a way to use the data loaded into Power query in formulas on a normal worksheet?

I've got 20 years of utilities, forms, classes, and other macros in my personal.xlsb file. It's over 1MB now and while I use some macros more than others I don't want to leave any out for when I need them. I know it's a big chunk of memory to load the file, even if particular modules aren't...

I have a Listbox on a userform and I want to load it with values from a range but only if another column has a specific value. My range is C2:C42 - I need the values to be loaded only if the text "Unassigned" does not appear on the same row in H2:H42.

Hi all I have a list of numbers in column A (list is dynamically loaded from a data base) which I need to concatenate (comma separated) into one cell, let's say B2. This could look something like: A B 305 305,407,809 407 809 I have 2 issues: 1) because the...

This morning when I loaded Excel 2010 with Vista, the same as I’ve always used, I noticed that all my column headings have changed from the usual letters to numbers. This is in an empty Excel. I thought maybe loading the program I've been developing would bring everything back to normal...