Programming

Can a checkbox be created with a logic function?
I currently have a SS that utilizes a column of checkboxes. I also have a macro that filters for checkboxes that are TRUE, thus hiding the rows with unchecked boxes. The two things I don't like with this configuration are that the checkboxes are too small, and when I filter, many of the unchecked checkboxes sup... 22 Feb 2010 20:57

macro in excel
how can i create a macro to seperate lines by a uniqe value.e.g if i have john doe for 10 lines and johnsmith for 20 lines, is there a macro to sperate each unique value? ... 18 Feb 2010 17:23

creating macro to seperate lines
how can i create a macro to seperate lines by a uniqe value.e.g if i have john doe for 10 lines and johnsmith for 20 rows, is there a macro to sperate each unique value? ... 18 Feb 2010 17:23

reference inside worksheet function
hi all !! i need a function like this next one ... ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999 ....but with A16 value instead of 999... can anybody help.. tx paolo ... 18 Feb 2010 16:16

activate, window activate?
Hi, I want code to fire when I deactive excel and select another program and then run again when I active excel again... Private Sub Workbook_SheetDeactivate(ByVal Sh As Object) Range("v3").Font.ThemeColor = xlAutomatic End Sub Tried several, what am I missing? ... 18 Feb 2010 13:59

Fire Code after Preceding Events Run
I'm trying to add some functionality to a workbook that is updated through an export process from a web application. Although I cannot access the code behind the export process, at a bare minimum, I believe the process asks the user to select a workbook to update, then opens the workbook, loads VBA which in tur... 18 Feb 2010 12:51

Macros in excel
how to find first empty cell in a selected column ie A12:A20 with a macro ... 18 Feb 2010 13:59

Cell content capture and release
Hey guys. I want to make a sheet that has a cell in it where I use a barcode scanner to grab a barcode. What I want is for the cell to grab the barcode, and fire it off to a specific cell, empty the reader cell, and wait for the next barcode scan, which gets filled into the next cell below the previous fil... 20 Feb 2010 15:47

HELP!! Formula for calculating overtime
I'm hoping someone can help me. I can't seem to figure out a formula to calculate OT for my staff. Regular hours per day are 7.5. I'm looking to create a formula for banking time which will break out in two columns hours worked over the regular 7.5 hours per day up to 11 hours per day, and in the second colu... 17 Feb 2010 14:31

Extract data from csv file
I was looking through this discussion group, found something close to what I need, but not being a programmer, I haven't been able to modify it to what I am attempting to do and I hope someone can help. The .csv files are split into groups by month (ie: "c:\Jan\file name.csv)". I need to search within the g... 22 Mar 2010 07:11