Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Combo Box - AfterUpdate25 May 2006 16:56 GMT4
Good day,
I am attempting to develop a project for school with three Combo Boxes
that will update upon user selection. Esstinally when I select the
first combo box, I was looking to get the data assocated with that
Cells(Rows.Count, "b").End(xlUp).Row25 May 2006 16:31 GMT1
So, you can use the formula in the subject line (Cells(Rows.Count,
"b").End(xlUp).Row) to select the last cell in the column.  But, I have
a table with a variable number of rows, which will most likely be
empty.
Userform.Caption is blank when reference passed to class25 May 2006 16:25 GMT3
'** In MyClass.cls
Private XLUForm As UserForm
Public Property Set XLUserForm(vData As UserForm)
Set XLUForm = vData
Some VB coding required25 May 2006 15:59 GMT3
basically i want
all rows on a worksheet hidden (except rows 1 & 2)
default in a2 to be "april" (so it doesn't allow a blank)
if cell a2 = "april" show rows 3:41
How do I set up a greater than but less than formula in excel?25 May 2006 15:56 GMT2
I am tring to sort data to look at one of three tables. Once it finds the
right table, then it produces a value based on the table. I can get the ones
to work for <50000 and >100000, but I am having trouble establishing the
criteria for the >499999 but >100000.
Transpose25 May 2006 15:51 GMT2
I am not a programmer, but can anybody help me on this:
I have data in one worksheet, in:
C9-c13
C15-C19
Formula Reproduction25 May 2006 15:35 GMT3
Okay, here's my formula, very simple:  
=D2/D51    
Now that resulting value beigns in E2.  When I try to drag the formula to do
the same things in every following cell in Column E, it doesn't work.  I want
Workbook_Open macro question25 May 2006 15:35 GMT3
I'm trying to get a message box to pop up when my workbook is opened. I found
this macro structure in a previous post:
 Private Sub Workbook_Open()
  MsgBox ("  text   ")
how do I copy worksheets between workbooks without the macros?25 May 2006 15:28 GMT1
I'm using Excel 2003 and have a function that exports worksheet tabs from one
workbook to another using the copy method.  Turns out that it copies
EVERYTHING - vba code, formatting, the whole nine yards.  Since I want to
keep the formatting (for display and print), is there a way ...
Find and copy25 May 2006 15:01 GMT2
I have a list of data several thousand rows long. For each time that
123 occurs in column F I would like to copy the text from (same row)
column A and paste it at the bottom of a list that starts in cell Z5.
I currently do it with an Excel List filtered and then copy "Visible
Running a .exe from VBA25 May 2006 14:54 GMT3
Hi All,
Does anyone know if it is possible (and if so how?) to run a .exe fil
from VBA in excel? Specifically, I would like to add a command butto
to my worksheet and when it is pressed it runs a .exe file which is i
Help, please25 May 2006 14:46 GMT7
Hi, I have a huge spreadsheet of baseball players....Some players played
multiple positions during a single season. What I want to do is find the
duplicate player ids for a given year and then find the position they
played most for that year and delete the other records. For example
No. of Columns25 May 2006 14:36 GMT1
This may not be the thread to ask this, but....
Quick question. Does anyone know if Excel 2003 has more columns than the 256
in older versions? I thought I read somewhere that it did.
I Import a company database into Excel frequently and Excel won't let me do
Opening MS Applications25 May 2006 14:18 GMT16
Is it possible to launch MS Office Outlook from Excel via a Macro?
TIA
Signature

gti_jobert

autosize25 May 2006 14:16 GMT2
I have a code that autosizes all my columns only when you, but it only works
when you click another sheet in the work book and then click back to the
sheet with the code. How do i get it to autosize when you move to the any
other cell instead of having to go to another sheet and ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.