form

I have a Combo Box with (3) Fields: SELECT [GP Schedule].[EVM/VM], [GP Schedule].BEID, [GP Schedule].BusinessEntityName FROM [GP Schedule] WHERE ((([GP Schedule].[EVM/VM]) Is Not Null)) ORDER BY [GP Schedule].[EVM/VM]; I have it setup and bound to Column 2 - which is the BEID. When I select...

I keep getting the aforementioned error. I have a module (modGlobals) which I use for all public variables... Below seems to be the offending Sub which is in a module. This code is used to populate a list box from entries on a spreadsheet. Sub GetList() If Right(frmMain.Caption, 3) = "V&V"...

I have a Query "qry_OnTimeDelivery_MetricData" in the query I have a column named Month01_Active. That field has either a 1, 0 or nothing in it for each record. Can I create a Form and have a field on it that sums that column (Month01_Active)? Thanks

Hi, I have a form on a tab in the spreadsheet that links to data on the first tab via VBA coding. I have updated the names of each column in the name manager part of formulas but 2 sections of the form aren't pulling the data through from the sheet like the rest of the form instead of populating...

Hi gurus in the sky I use form control buttons to make life easy for my users. I want to disable a right click totally. I have discovered how to disable the "cut, copy, paste etc" menu by pasting into ThisWorkbook Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target...

Good afternoon, I am attempting to streamline a tracking sheet being utilized by several of our employees. There are about 100 worksheets in the workbook currently, each named after a unique unit number. This makes it a nightmare to navigate efficiently and I am attempting to use an Input...

Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain things...

I have been asked to spread a series of values over a set number of months that will form a data series that will produce 45 degree line when graphed. Any ideas on the excel formula to calculate the monthly amounts?

Ok guys i know the short cut for starting and stopping a recording macro is Alt+T+M+R. My problem is im wanting a macro that will insert a new Row in my table, in form view. (Select anywhere on the table, click on insert at the top ribbon, then click on "Form" on the top right ribbion, then...

Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain...

Good afternoon all, Is it possible to display a chart/pie chart in a User form?

Hi there, I created an home inventory in excel. I would like a popup to display information about the item when i click on it. I know Microsoft access has a home inventory and when an item is clicked on an asset detail popup is created. Just wondering if i'm able to copy this form to excel or...

I am constructing a macro to perform sorting on different selected named ranges provided by a user form which has a combo box and I do not know what best practice is: Call the user form from within the macro or call the macro from the user form. I would appreciate any advice and...

Excel VBA beginner I've prepared a userform with a two tab multipage area. I added several labels, textboxes and combo boxes within the first page but had not yet started any code work. I clicked outside the multipage form to edit some other objects and now I am unable to see the multipage tabs...

Hi so I am wondering if there is any feature or other that I can utilize in an excel sheet that will make it so that employees when filling out a particular field in the excel form, have to put a Sunday date in a particular cell. I want it to prevent them from putting any other date in that week...

When Hook The Window Class #32770 Through Form , It Does Work Fine But When SubClass This Window Inside CBTProc , System Crash And Hang Up , What s Wrong ? Because Of Not Define Handle Window MayBe Happens Crashing ? In Access Application When Open Form And Hook Window Class #32770 , Again...

Good Evening, I have two queries: Firstly, I have a excel spreadsheet where it imports the booking data from the word form. Owing to the word form timing format, the timing in excel appear as 0100-0200 whereas I would like them to appear as 01:00-02:00. Is that possible through coding or...

I have reviewed the similar posts and none of the recommendations fix my issue. I have a form with several text boxes that I'm trying to write to a sheet (20 lines, 6 cells per line). It takes about 58 seconds to write this to the sheet but takes a fraction of a second to load the form from...

I have a user form with several option buttons After selecting an option button and clicking on Ok, I would like the button to show the last option button selected it would be appreciated if someone could advise me how to do this

This is complicated to explain, so bear with me please I have a for next loop set up as follows For j = 2 To LastRow Step 1 a = Cells(j, 53) If a = "1" Then tcsorting.Show Else Cells(j, 8) = Cells(j, 53) End If Next If A = 1 then a form called tc sorting...