add below Microsoft Scripting Runtime library from tool--reference
From: Indrajit $nai talk2indra...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, August 19, 2013 4:08 AM
Subject: $$Excel-Macros$$ Need urgent help on macro error.
Hi All,
PFA.There are three argument in UDF first lookup value ,
lookarea(range),colnum
From: Rashid Khan prkha...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, August 18, 2013 9:32 PM
Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values
Dear All
I am facing a small problem I like to have help for expert.
I am trying to write a macro which will browse the folder and open the
selected file one by one.
But whenever I am opening a folder from macro I could not see any file in
that folder.
If I am opening the same folder directly
Dear Shrinivas,
Pl see that u have filter the ext with the following one.
.Filters.Add Excel, *.xls; *.xlsx; *.xlsm; *.xlsb, 1
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas
Dear Indarjit
Can you share a file with me because I have the same work
Regards
Shrinivas
On Mon, Aug 19, 2013 at 2:33 PM, Indrajit $nai talk2indra...@gmail.comwrote:
Thanks a lot to both of you.
You guys are simply awesome :)
On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi
Dear Ahsish
waiting for help
Regards
Shrinivas
On Sat, Aug 17, 2013 at 11:50 AM, Shrinivas Shevde
shrinivas...@gmail.comwrote:
Dear Ashish
Please find attached File
Regards
Shrinivas
On Sat, Aug 17, 2013 at 9:41 AM, ashish koul koul.ash...@gmail.comwrote:
Hi can u share some sample
I often have to move cells in order to have them in a row (going across)
instead of in a column (going down). Is there a way to simplify this so
that I don't have to manually cut paste or move each cell?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
I often use Excel to organize rows of text (i.e. terminology, examples,
subsets, etc.) and often need to include images in a row. However since
images aren't actually in a specific cell they therefore aren't linked to
the rest of the information in the row, making it impossible to sort the
Hi Chaya,
You no need to cut and paste the each cells. Simply u just copy the data
which u need to be in row. then right click-paste special-values (and
select transpose). Now you data will be pasted in single row.
Note the same method u can use to copy the data in single column if it is
in
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question - is there a way to split it up into several rows (for example
5 rows, with 3 columns per row)?
On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
Hi Chaya,
You no need to cut and paste the each cells.
you mean same data in each row..?.. or can you share me your file with
requirement..?
like below..
[image: Inline images 1]
Thanks Regards,
Prabhu R
On 20 August 2013 04:02, Chaya Cooper chayacoo...@gmail.com wrote:
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper chayacoo...@gmail.com wrote:
Unfortunately, the data in each row is different
I've attached an image with an example :-)
On Mon, Aug 19, 2013 at 6:36 PM,
paste this on userform1
'
Dim Target As Range
Private Sub CommandButton1_Click()
Target.Offset(1).Select
Unload Me
End Sub
Private Sub TextBox1_Change()
Target = TextBox1.Text
End Sub
Private Sub UserForm_Activate()
Set Target = Selection
TextBox1.Text =
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper chaya...@gmail.com
A tutorial I'm using (to create a multi-select box) suggests right-clicking
on the sheet tab to View Code, but that option isn't being displayed (I'm
running Excel 2008 for Mac). Any suggestions how I can view the code?
My apologies for what is probably a simple issue, but I've been unable to
Am just asking you to share the excel file.
On 20-Aug-2013 5:50 AM, Chaya Cooper chayacoo...@gmail.com wrote:
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
hi chaya,
hope if u share the file.. it will be so fine
try this
Sub choose_file()
Dim flname As String
Dim fd As FileDialog, fl As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.AllowMultiSelect = True
.Title = Please choose the file
.Filters.Add Excel Files, *.xls*, 1
.Show
can u share a sample file
On Tue, Aug 20, 2013 at 3:38 AM, ashkan kordmahaleh ashkank...@gmail.comwrote:
I am trying to use some VBA to change backcolor of my userform txtbox when
the linked cell value changes. Any ideas?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Dear Ashkan,
on textbox enter event write a code
Me.txtshiptoparty.BackColor = vbGreen
after on textbox exit event write again the same code with different color.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20,
Dear Chaya,
Pl share a sample sheet with us.
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper chayacoo...@gmail.com wrote:
A tutorial I'm using (to create a multi-select box)
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar prashant...@gmail.comwrote:
Hi Chaya, Prabhu,
Done with a simple macro.
Use Control + Shift + A at particular cell where you want to transpose.
This you have to to for every entry.
In case you
Ashish,
That's exactly what I needed :-D
Would you mind showing me how to use it?
- Chaya
On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar
prash...@gmail.comjavascript:
wrote:
=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample -
Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0)
'Sample - Unedited'!$A$1 - header of source column
COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3
(COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6
'
0 because source data is in same
Dear Chaya
The solution from Ashish (using offset command) has lesser effort than
using macro. I suggest to use the same for your multiple entries.
using macro is possible in 2008 . no issue. For your information. you have
to use Ctrl+ shift + A at first column of each row required.
Regards
have you tried using form controls or active x control list box for multi
select options
On Tue, Aug 20, 2013 at 10:57 AM, Chaya Cooper chayacoo...@gmail.comwrote:
And these are the options that are displayed when I right-click on the tab
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Respected Chaya Cooper,
Please check the following link and see whether it helps.
http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/
To view code you can also open the VBA window by pressing ALT+F11 and go to
project explorer window and go to the module folder to open it and see the
26 matches
Mail list logo