Search:

Hi all,

I am trying to extract messages from outlook express on a server and file them in a folder. - contact, subject and text



Does anyone know if this is possible or can direct me to a...

Hi all,

I am trying to extract messages from outlook express on a server and file them in a folder. - contact, subject and text



Does anyone know if this is possible or can direct me to a...

Unfortunately Me.Controls does not appear to work when you are dealing with an activesheet i.e controls in an activesheet as opposed to a form.

Using VBA and tried this code,but it does not seem to recognise any textboxes:

Dim dCont As Shapes
For Each dCont In ActiveSheet.Shapes

If TypeName(dCont) = "TextBox" Then
dCont.Visible =...

Hi All,

I have a worksheet with a number of textboxes on it . Is there anyway I can call all the textboxes and clear them either thorugh a loop.

Thanks in advance

Hi Guys,

I am using excel 2002 edition...

Does anyone know how to make a userform always open maximized.

I am using VBA and want to make sure that anytime the user form is shown it is always maximized.

P.S I don't seem to be able to...

Hi All,

I am trying to find out how I can convert column letters i.e AA , AB to numbers .

In otherwords what number would represent AA.


Thanks

Nike

Hi Guys,

Unfortunately I don't have VB6 I'm working with VBA1

Hi All,

I have a few columns in excel and I want to use these columns to populate a list box. Does anyone know of a fast way to do this i.e I tried using Row source i.e

ListBox.Rowsource =...

Thanks Sabin 33 You are a Hero!!!

Thank you sooo much!

Hi Sabin,
This works fine for the names aspect, however what I am hoping to do is to be able to also get the persons age,height etc, this is mainly because :

I want to have a combo box which...

Thanks Sabin, I'm going to try this!!

Hi Sabin,
I've tried what you wrote but it comes up with a syntax error

Hi I've tried the code you suggested and it still gives the same error. Not sure what's causing it because in the watch window the expression:

"I13:I" & LastStartDateRow = "I13:I37"

Which is...

Unfortunately I don't know how to use access and this is something I need to do as soon as possible

I have office2003.....So Microsoft Office Excel 2003

Dear All,

I am trying to specify a range that I know the start of but do not know the end...at the moment I'm doing the following:


Dim LastStartDateRow
Dim NextAfterLastStartDateRow
...

Hi Guys,

I have the following code:


Range("I" & NextAfterLastStartDateRow).Value = Application.WorksheetFunction.Sum("I13:I & LastStartDateRow")

Range("J" &...

Thanks Shuja,

I have been looking at it so intensely that I couldn't spot that...thanks!!
I'll put an if statement to stop this from happening...

Very grateful...

P.S Please can you advise...

Dear All,

I have the following code:



Dim MyCountNonCompliant As Integer
Dim MyCountCompliant As Integer
Dim MyCountToBeCompliant As Integer

Hi Guys,

Thanks so much for your responses.

Firstly I am using VBA. With the attached file, unfortunately I am unable to open it at this stage as I don't have VB6 on my system at present but...

I have the following columns in an excel sheet:

Column 1: Department (This gives a list of department’s i.e Biology, Chemistry etc)
Column 2: Sad People (This has a list of people i.e mark,...

Dear All,

I am trying to get all visible cells in excel using the following code after applying a filter:

For Each myCell In Range("A2:A58").SpecialCells(xlCellTypeVisible).Cells

Is there...

Shuja,


1) I've used Exit Sub and then End Sub after that....Thank you so much this was something I'm unaware of and inthe book I am using to learn it always uses End Sub.

So Thank you very...