control

Hello! I was wondering if someone could help me with the following (please keep in mind that I'm a bit new to VBA): I have a spreadsheet where I want to create one combobox per cell so the user can type in a keyword selection, pick from the drop down, which will return results and auto populate...

Hi No one talk about "Workbooks.close" --> collection leve<collection level="">. I did google search and they are all talking about "Workbooks("name").close" <-- workbook level<workbook level=""> The code below, will close the first workbook no matter how many workbooks are open. My questions...

I wish to give a workbook to members of our group. It contains a listview control, but it appears that control is Missing (even though it was in the xlsm file I gave them). I thought adding a Reference would fix this, but it appears not. Is there a solution for this? Thanks,

Hi I've been looking at tutorials but can't quite get this to work.. I have a table with data set <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> CompanyID CompanyName Field Name Control Centre Position Field Source Country Code Country Name GDS 12345 ABC COMPANY...

Hi, long time listener, first time caller... I've searched both the internet at large and this forum, and all the responses that pop up go in reverse - how to use the variables in VBA to reference cells in various dynamic ways. I have a variable in my VBA code (based on an embedded checkbox...

VBA Webbrowser control disappears from multipage site after switching between Page1 and Page2 multipage sites.Is there a solution/code to this problem witDisappearshout using the Tab Strip control?

I am Using a Forms Control button to run a macro. I would like to have the Button disabled till certain requirements are met. How can I disable the button. It is called Button 6 I have tried the following code but the button still works as normal even though the sheet is protected...

Hi, Searching for help to automatically fill missing information in column E where cells in column D match: <colgroup><col><col></colgroup><tbody> Control Number Control 50071879 50071879 50071879 50071879 Critical Spares for Girth Gear 50071879 50071879 50071879...

Hi, has anyone knowledge of listview controls? Having just set one up on a Userform I'm having a bit of trouble. Can you only detect a click in the first column ? Also if you click another column in say line 3, column 1 in another line may become selected. Is there any way around this? Should...

Hi there - I'm working with a data set that is in a less than friendly format. I'm trying to turn this data set into a more user friendly format for querying and pivot tables. Here's how the data is currently structured: <tbody> Business Entity Control1 Control2 Control3 Control4 Control5...

I have a form that when the user double-clicks a listbox, the record is retrived and placed on the form for editing. I keep getting the runtime error when I try to clear the form. The code is below. 'Traverses form and clears contents from textboxes For Each cCont In Me.Controls...

New to Access programming. Just created a form and wired events to it but every time I bring the form up on either the control or an event like Form_Load, I get a "User Defined Type Not Defined" error. I wired the control events through the property sheet and used the Code Builder option. I'm...

I have a column of data that shows whether a value is over or under a target value. I have the over values (>0) highlighted in red and the under values in green. By "highlight" I mean the fill color, not the color of the characters themselves. The column has a header with the characters "O/U"...

I understand Excel can't open a connection to itself, and create an sql-based Recordset without memory leaks. Has this been fixed in later versions, or does the problem remain? In which case are there other solutions? My goal is to output my query (or equivalent) to a Listview control. Can I...

Hi I have a list of dates in E5 to E7, in long date format. I have a form control with an input range of E5 to E7. The cell M5 also has long date format and is the cell link for the format control. Cell M5 does not display the correct dates from the dropdown list and instead displays 1,2 or...

Hi, I've some active X controls which have taken on odd behaviour. They are label and combo box controls. As I mouse over them the cursor becomes a 4 pointed thing whether I go to design mode, or not. There's no dropdown action. A right click shows a different menu to the expected one starting...

I have a spreadsheet with 25,000 rows and about 500 columns of data Many of them have formulas in them, such that, when an entry is made in the column of "how many to order", ALL the formulas will be affected. That causes about a 2 to 3 second delay before the user can enter the next value. Is...

Hey, I am a novice when it comes to using ActiveX Control and VBA to build macros but I am having incredible difficulty getting something simple to work. I want to build a macro which hides and unhides 3 columns in my excel sheet however when I run the macro it unhides unwanted columns and...

Hello everyone, I made a ComBobox (ActiveX control) with 6 items "FR5CP" "CR5CP "NR5CP" "CR5TP" "FR5CU" "CR5CB" I want a solution for this: when I write F it will filter the other ones and stay only FR5CP and FR5CU.I mean to look for the item while writing. nother Thing:when...

I use this Option Explicit 'Popup objects Private cmdBar As CommandBar Private WithEvents cmdCopyButton As CommandBarButton Private WithEvents cmdPasteButton As CommandBarButton 'Useform to use Private fmUserform As Object 'Control array of ComboBox Private colControls As Collection...