Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

How to write Greek letters in VBA?

Hello again.
In a combobox, some items are Greek letters.
By clicking "OK", a chart is generated from data in many sheets through a ".find()" which looks for the contents of the combobox (which may be Greek characters, such as alpha, beta, etc.) and takes the values of cells to construct the chart.

However, I must write the word to be sought not only within ".find ()" but as a case of "Select Case ". So how to proceed?


Post your answer or comment

comments powered by Disqus
there's one integer variable, j.
I want to use VLookup function here, and the table Array parameter
should be Column j to j+1
But how to write this code in VBA?
Application.VLookUp(Cells(1,1), COLUMNS(j,j+1), 2 FALSE) ???
It report erros like above.
Thanks.

Does anyone know how to add a DriveListBox in VBA for Excel? Any help ASAP would be great!!

I have been trying to figure out how to write a formula in excel that does certain things. Here are the things I am trying to do.

1. if I put a number (1,2, 3 ect) in we will say c1 I want D1 to say WW1 or WW2 ect depending on the conflict.

2. If I put a number (1, 2, 3 ect) in say F1 I want a proper name to show up in G1. Like 1 in F1 and in G1 I want a name like Chicago.

I hope that someone gets the drift of my questions. I have not written any formulas for numerous years and I am totally lost in Excel, thus I am solicitating someones assistance.

thanks for your help.

Cheers
Larry

I am working on this project & I cant figure out how to add a letter in
front of each number in a cell without clicking in to each individual cell
and typing it in. (very time consuming and tedious) The problem is - it's not
all the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.

Example:

X39655
X39656
X39711
39662
39664
39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged
:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,
finally replace the old values with the new

Regards,

Peo Sjoblom

Hello Friends

There is an immediate need at my work place where I need to convert huge
amount of data into different cases like proper, lower, upper and sentence.
If there is any freeware that lets me do all of the above please advice. I
would also love to know how to write such programmes in VBA for Excel as an
interest(specially sentence case).

Thank you

Philip Jacob
Senior Executive Quality Appraisal
First American Corporation

I am working on this project & I cant figure out how to add a letter in
front of each number in a cell without clicking in to each individual cell
and typing it in. (very time consuming and tedious) The problem is - it's not
all the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.

Example:

X39655
X39656
X39711
39662
39664
39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged
:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,
finally replace the old values with the new

Regards,

Peo Sjoblom

Dear Friends,

Do you know how to write a marco in Excel to delete worksheet automatically, without prompting me to click OK?

I have tried one by using the command:
Sheets("Sheet2").Delete

but it will ask me to click OK before delete it. It looks not professional.

Thanks a lot.

Hi,

Does anyone know how to write a macro in an Excel file which can copy and
append the data in an Excel worksheet to an existing Access file? Also at the
same time, a graph in that Excel worksheet is linked to a PowerPoint file. So
when the macro is run, I hope both the Access and PowerPoint files will be
updated automatically.

Since I am doing some works which require data analyisis by using Excel, I
currently need to copy and append the data to the Access database manually.
Also I copy the graph from the Excel file to the PowerPoint file manually as
well. It would be great and save a lot of time if one macro in Excel can
manipulate between Excel, Access and PowerPoint?

Thanks and regards,
Jackie

Hi,

How to write a formula in a cell as per the following condition?

Cell E10 = Start Date
Cell F10 = End Date
Cell H10 = Current Date

If StartDate (E10) is less or equal to CurrentDate (H10) then
=SUM(H10-E10+1)
Else
=SUM(H10-F10+1)

I need to write this formula in Cell J10.

Please help.

I have one excel spreed sheet, I need to delete all the
empty row, also some of cell in columnF if is the space,
then this record need to delete as well.
Anyone know how to write the vba macro?

thanks.

Lillian

I want to input following array formula in range D2 through vba:
LOOKUP(COUNTIF($C2:$C$200,$C2),{1,2,3,4,5,6,7},{"-I","-II","-III","-IV","-V","-VI","-VII"})
For this purpose I am writing following codes:
Range("D2").FormulaArray = "LOOKUP(COUNTIF($C2:$C$200,$C2),{1,2,3,4,5,6,7},{"-I","-II","-III","-IV","-V","-VI","-VII"})"
but it is showing mistake in coding.
Please help me solving the problem.
Further after putting this formula in D2, I want to copy it up to D200. Please help me how should I do it in VBA.
P.S. I am using Excel 2003 and the above formula is perfectly working when manually pasted in cell and dragging it up to D200

Hi,

I posted this question yesterday, but the parameters have now changed and the formula I need is different.

I need to know how to write the following line as an Excel formula. It would be placed in every cell in another worksheet. Below is an example of what it would say in (for example) cell F3 of Worksheet 2.

The formula I need to write is...

If any one of cells F3:F500 in Worksheet 1 contains the term "NORTH_AMERICA", then this cell will show "NORTH_AMERICA" in black. If FALSE this cell will show "NORTH_AMERICA" in red.

I have no idea how to write this. Could someone please help?

Thanks,

Dom

Hello
How to replace column letter(s) (or column numbers) in refferences with a
result of a function using the old column letter(s) (or column numbers)?

Hi there

While using Excel Search Function in VBA programming, I got
"Sub or Function not defined!!" Error...

But need to use the Search funtion..
So please tell me how to use it?

Thanks in advance
john best

Hi,

I read in this web site how to send & receive email in Excel, however I tried to run this code the error occurs in Format function with the following message: 'Wrong number of argument or invalid property assignment.

Mail Sheet Array using VBA in Microsoft Excel

• Create a new workbook with the SheetsArray.
• Save the workbook before mailing it.
• Delete the file from your hard disk after it is sent.
Sub Mail_SheetsArray()
Dim strDate As String
Sheets(Array("Sheet1", "Sheet3")).Copy
strDate = Format(Date, "dd-mm-yy") & " " & Format(Time, "h-mm-ss")
ActiveWorkbook.SaveAs "Part of " & ThisWorkbook.Name _
& " " & strDate & ".xls"
ActiveWorkbook.SendMail "ron@debruin.nl", _
"This is the Subject line"
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
ActiveWorkbook.Close False
End Sub

Could any one help me to understand and how to fix this error.

Thank you very much

how to write or label point once chart has been created.

Hello,

I have a program that needs to be installed on customers' machines
This excel-VBA program is using the solver add-in in excel. I'm no
sure if the users will have this add in installed on their machine. S
I would like to see if there's a way to include the add-in file with m
software and some how install the add-in using VBA coding, at th
beginning of the setup, and on the first run, on client's computer.
If there is a way, please guide me as of how to write this code in VBA
(Hints on command would be of great help.)

Thanks in advance

--
Message posted from http://www.ExcelForum.com

Hi, I put a combo box in one of my exel sheet, I put a code combo box
type(not a form combo box type) because I dont want to put the combobox
entries in a exel sheet, my question is, how to add the entries in the combo
box??? (I mean, how to write the code in VB)
TIA

Help needed,

Can anyone help me in finding how to write the command in VBA to determine what Cell was selected in a worksheet? The objective is to know what Cell has been selected by double click event to pop up a userform with a calendar from which the user can select the date. I am looking at making it dynamic so I do not select a particular range.

Can this be achieved? I guess yes, but how?

Looking forward for your feedback.

Appreciate your help.

Hi All,

I am new to excel, currently am using MS Excel 2007 for my project.

I have a roadbloack i need to retrieve distinct values from available list of values(text).

scenerio :

I have data from M4 : M71 --> few are repeated.

I want to apply formula on it to get only unique values from list.

if anybody help me out how to write function.

Thanks in advance,

sk

Dear all,

I have an Excel macro program which uses ADO connection. It connects to our
AS/400 database. When the program connects to the AS/400 system for the first
time after the program is opened, it prompts a AS/400 login dialogue box and
then the user keys in his/her user name and password. If I want to capture
the user name from the AS/400 login dialogue box, then how to do it? How to
write the code in Excel macro? Is it possible?
Thanks in advance!

Ivan

Hello,

I am trying to write a script in VBA which copies a row from Sheet 1 to Sheet 2, if the value for the first column of Sheet 1 is greater or equal to 10. For some reason if I run the code i get the error message type missmatch 13.

Sub Macro1()

Cells(1, 1).Select
For i = 1 To ActiveCell.SpecialCells(xlLastCell).Row

Cells(i, 1).Select

If ActiveCell.Value >= 10 Then
Rows(ActiveCell.Row).Select

Rows(i & ":").Select
Selection.Copy

Sheets("Sheet2").Select
ActiveSheet.Paste

Sheets("Sheet1").Select

End If

Next i

End Sub

Hello All ,

I would like to know how to write VBA code to copy a specific range in Excel and then save it in .JPG format ?

Please suggest.

I don't know how to write this VBA in this condition
(1) Click the "Open" button to select the multiple csv files
http://img220.imageshack.us/my.php?i...1133901ee9.jpg
http://img169.imageshack.us/my.php?i...2031132uo6.jpg
(2) I had done the multi-selection command as below:

Code:
Sub Test1()
 Dim Finfo As String
 Dim FilterIndex As Integer
 Dim Title As String
 Dim Filename As Variant
 Dim i As Integer
 Dim Msg As String

' Setup lists of file filters
 Finfo = "Comma separated Files (*.csv),*.csv," & "All Files (*.*),*.*"

' Display*.* by default
 FiterIndex = 5

' Set the dialog box caption
 Title = "select a File to Import"

' Get the filename
 Filename = Application.GetOpenFilename(Finfo, FilterIndex, Title,   MultiSelect:=True)

' Exit if dialog box canceled
 If Not IsArray(Filename) Then
 MsgBox "No file was selected."
 Exit Sub
 End If

'Display full path and name of the files
 For i = LBound(Filename) To UBound(Filename)
 Msg = Msg & Filename(i) & vbCrLf
 Next i
 MsgBox "You selected:" & vbCrLf & Msg
 End Sub
(3) The selected files will show in the list box. Use the mouse to select the file(s) in the list box that you want to open. When click the "Run" button, it will load the selected csv file(s). Or click the "Delete" button to delete the selected file(s) from the list.

http://img169.imageshack.us/my.php?i...6799144hn6.jpg

Thx for anyone help~~ It is very important for me~~

EDIT: cleaned up html tags - Moderator


No luck finding an answer? You could always try Google.