ComBoxes Are Inactive

Jun 8, 2006

I added a combo box to each sheet of a workbook. Each box referenced a range within the sheet and linked to a cell on the sheet. Each box was tested and worked perfectly. Yesterday. On opening the book today, however, I've discovered each combo box is dead in the water. They are totally inactive and can't be activated in any way. I've checked the properties sheet for each and can't see anything out sorts. As a test, I added a new combo box to a sheet, and interestingly enough, it not only works fine, but also seems to have activated the original box, which also now works fine. Other boxes on the other sheets are still inactive, however.

View 5 Replies


ADVERTISEMENT

Linked Comboxes Populating Multiple Textboxes

Oct 17, 2009

I have a user form with:
ComboBox 1
ComboBox 2
Text Boxes 1 - 12

ComboBox 1 runs through a sheet range and removes the duplicates values
ComboBox 2 is linked to Cbx1 and is populated with the second column of that range, depending upon Cbx1's value.

Trying to populate the twelve Text Boxes with the remaining row of values. To program those boxes to clear each time either Cbx 1 or Cbx 2 is changed. This is the section of code I can't make work properly. I don't raise any errors, but the TextBoxes remain blank none the less.

View 2 Replies View Related

VBA Inactive Worksheets

Dec 10, 2009

I am having trouble referencing a range in an inactive worksheet to feed an vba array. this is the following vba code that does not work:

View 4 Replies View Related

Inactive Cells

Oct 6, 2009

i have a workbook that contained a single sheet, i ciopied this sheet and amended them accordingly (ie picking up different variables etc).

For some reason every now and again some of the cells on the sheets that are effectively copies of the original dont update, i literally have to click on them and hit Enter.

I know that calculation is switched on as automatic.

View 9 Replies View Related

Close Inactive File

Sep 21, 2009

close the inactive file
I'm using the

View 4 Replies View Related

Activate Inactive Workbook

Aug 2, 2009

I am having a "cosmetic" issue that I was curious if I can fix it.. I have a workbook that opens a network workbook, saves some data to it, and then closes the network workbook.

Everything is working fine, except I cant get the code to "reactivate" the initial workbook. After excel saves and closes the 2nd workbook I opened, my screen stays on my desktop, instead of refocusing on the initial workbook. I have to manually click on the initial workbook in my taskbar to bring it back into focus...

I thought the below code would bring the inital workbook back into "focus" on the users screen, but it's not working.

Windows("NEWRightFit.xls").Activate
Sheets("Sheet1").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.ScreenUpdating = True
Windows("sxssubmit.xls").Activate
Confirmation.Show

End Sub

I just moved the Application.ScreenUpdating line as initially I had it at the very bottom, but that did not correct. The confirmation.show is just a dialog box that informs the user the changes were saved successfully. I would like the first workbook "sxssubmit.xls" to come back into focus automatically though, without the user having to manually select it from the taskbar.

What is my code missing?

View 9 Replies View Related

Use Of On Time To Kick Inactive Users

Apr 16, 2014

I use the 'on time' function to kick users out of a shared workbook after 30 minutes of inactivity (i.e. no cells updated). Technically it works, as it does kick out the users.

However the time after which it does so seems to bear no relation to the time I have instructed. Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter).

View 6 Replies View Related

Get ActiveCell Data From Inactive Sheet

Aug 8, 2009

I need to grab data from one sheet while I'm in a different one - same workbook, however. From the first sheet, the data that I need would be an "activeCell.value" issue. From the other sheet, however, how can I get that cell's data - an "inactiveCell.value" call, in essence? Right now, I'm getting around it by assigning the value to a global variable but that seems wasteful.

View 4 Replies View Related

Create Range To Inactive Sheet

Sep 17, 2009

I want to create ranges in a worksheet that is inactive.I have 3 sheets in the worksheet and i want, while the first sheet remains active, to create ranges in the second one.

I'm using the following code that creates no errors no matter how i use it but it works only if the second sheet is active.

View 10 Replies View Related

Clear Filters From Inactive Sheet VBA

Dec 15, 2009

In VBA, is there code to clear all filters from an inactive worksheet or does the worksheet need to be activated?

View 14 Replies View Related

Show Inactive Workbook Filename

Jun 8, 2014

I open two spreadsheets only. In one of them I would like the filename of the other spreadsheet shown in cell A1.

The reason why is the filename is a 6 number date and I'd like to confirm it showing in full format.

View 3 Replies View Related

Change Activecell Of An Inactive Sheet

Dec 18, 2008

CopyPaste operations leaves the goal range selected and I don't want that. The .Activate and .Select methods seem to require that the cell to be selected refers to the ActiveSheet.

What I'm doing now to change the active-cell is kind of:
1. Disable ScreenUpdating
2. Save a reference to ActiveCell
3. Activate the relevant goal-worksheet
4. Change the ActiveCell to the upper-left-cell of the Selection
5. Come back by the reference in point number 2
6. Enable ScreenUpdating.

It works, but seems to me as a huge job for something as simple than "collapsing" a multi-cell-selection. Another irritating problem is the slight screen-shaking caused by the disabling/enabling ScreenUpdating.

View 9 Replies View Related

VBA Code To Close Inactive Workbooks

Sep 7, 2009

I tried to use Workbooks("Inactivebookname.xlsm").Close False
and many variations thereof, but I simply cannot close this workbook when currently another workbook is active.

I have no problem in closing an active workbook with
ActiveWorkbook.Close

View 9 Replies View Related

UDF In 2007: Inactive After Re-loading File

Nov 11, 2009

I'm just trying to figure out how to implment UDFs. I got a nice tool that provides linear interpolation for a data table. Unfortunately after saving, closing and opening the file the cells only show #NAME? in it. Do I have to activate macros or something like that?

View 9 Replies View Related

Automated Reply To Inactive Window

Jun 30, 2007

I am using PrimoPDF, as suggested elsewhere in the forum, to attach a PDF to an E:Mail and send it automatically, it works a treat ... however, I do have to manually intervene to click on the OK button & then again to click on YES when the filename is duplicate. I would like to automate these actions and am looking for a way to do it. It looked like the SendKeys command was perfect, but I'm not 100% sure how to do it. The PrimoPDF window is open, named as "PrimoPDF", but is not my active window, so I have put PrimoPDF.SendKeys "{Enter}"

... into the program but I am getting the error message "Run Time Error '424': Object required". Is this something to do with my code ? I am guessing that the program isn't recognising that PrimoPDF is an open & inactive window, so am I missing a prefix here or is it something more serious, like having to add a new Component or Additional Controls ?

View 3 Replies View Related

Make Button Inactive Until There Is Data In A Certain Cell

Apr 21, 2009

I have a button that has a macro asigned to it. i don't want it to be active
or able to run unless it sees data in cell D25.

View 2 Replies View Related

Copying Next Inactive Range To A New Consecutive Sheet

Mar 4, 2009

I tried to save a macro but it doesn't work (I am inexperienced!).

What I need is to copy five columns (e.g. range C:G) and copy it in another sheet ('1' range C:G). Subsequently, I have to copy the next range of five columns available (i.e. range H:L) and copy it in the consecutive sheet (i.e. '2' range C:G), and so on.

View 14 Replies View Related

Check Box(es) Inactive/active Depending On Value In A Cell

Dec 27, 2006

I have a drop down lets say in cell A1. Based on what value is selected in A1, the user should see a different set of check boxes. My thought, which may not be the best way to implement this, is to have all the check boxes and depending on the value selected in A1, the check boxes that are relevant should be active or visible, while the unneeded ones are inactive or invisible.

View 9 Replies View Related

Automatically Close If A User Is Inactive For A Period Of Time.

Nov 13, 2008

We have one shared excel workbook and it is used by many people (more than 20 simultaneously), is there any way to auto save & close the workbook (session) if a user is inactive for specified time.

View 2 Replies View Related

Excel 2007 :: VBA To Make Command Button Inactive Until User Field Selected

Nov 14, 2011

I am creating a userform in Excel 2007 which requires a user to pick their name from a drop down box then press Ok, what i want to do is disable the Ok button until the user field has been selected.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved