In principle that should be possible, but without knowing how the main
worksheet is structured it is difficult to make any specific
suggestions. It would help if you were to post a sample workbook or
described the structure in some other way.
On Oct 30, 7:13 am, Leo wrote:
> Hello! noob here :)
Let's assume that your 3 macros are located in a standard VBA module
and look like this:
Sub Macro1()
MsgBox ("Macro1")
End Sub
Sub Macro2()
MsgBox ("Macro2")
End Sub
Sub Macro3()
MsgBox ("Macro3")
End Sub
Now insert a UserForm in your VBA project then drop a ListBox (named
ListBox1
blue
On Oct 28, 1:02 am, RolfJ wrote:
> What do you mean by 'Any color?'
>
> On Oct 27, 6:01 am, Bajji wrote:
>
>
>
> > Hi Rolf,
>
> > Let me put an example:
>
> > 1. Assume sheet1 has some information from Cells ranging A1 : G20
> > 2. When I run the macro, it should pop user form with 2 input
I have 3 different macros that work, and as opposed to giving them
each their own ctrl+ key combinations to run, I'd like to create a
kind of drop down msgbox or something like that that would list the
different options available to the user so that they can select the
appropriate macro to run.
I
Try looking at the DATEVALUE function in Excel.
On Fri, Oct 30, 2009 at 8:00 AM, manni...@nationwide.com <
manni...@nationwide.com> wrote:
>
> I'm using a access macro to export access crosstab query results to
> excel. Everything works
> great, except that the column names are dates that expor
Hello! noob here :)
I have a project where I am trying to separate out a huge spreadsheet
into multiple tabs.
So, the main worksheet has unique Profile Numbers, and then data
associated with each profile #.
Is there an easy way where each new profile # is split into a new tab?
Please advise & do
I believe your problem is that in the Access database,
the field that has the date is really set up as a TEXT field.
the values only LOOKS like a date.
When the data is exported to excel, Excel assumes that
if the column is a text format, then it'll display it as text.
I have several of these.
I
Hi All
I am an excel user with negligible knowledge if VBA codes.
I want to know if following is possible by any generic macro:
-->My objective is to consolidate few number of files (say 20 files) where
data is there in just two fields i.e "Country" and "Sales in USD". To
clarify more: There
Thanks. My apologies for the duplicate postings. I didn't realize that
hitting tab or some other combination opened an new post screen.
The loop is one big counter.
On Oct 29, 10:53 am, Paul Schreiner wrote:
> No, because VBA executes "linearly".
> meaning that if the command: Select Case A-B
>
I'm using a access macro to export access crosstab query results to
excel. Everything works
great, except that the column names are dates that export to excel as
text. Excel formulas do not recognize it as a date, and dependent
formulas result in errors. Excel does not recognize them as a date
Dear Friends,
I need help in writing macro to provide multiple protection of a work
sheet .
ie two or three passward can be provided in a single work sheet and
every user would be restricted to edit the area where he is not
permitted to edit .
kindly help .
thanks and r
Hi Anish
I Have corrected the code and it works fine now:
Pls note that it runs on the ACTIVE SHEET. you may change it later.
Sub Test()
j = 1
While j <= Cells(65000, 1).End(xlUp).Row
For i = 2 To Sheets("Replace_Values").Cells(65000, 1).End(xlUp).Row
If Cells(j, 1) Like Sheets("Replace_Valu
Thank you friend, i didn't create any excel file for that, this my concept ,
I new to VBA, i didnt know how to start,
sorry for the inconvenience caused
On Fri, Oct 30, 2009 at 1:28 PM, sudhir kumar wrote:
> *Hi friends it is interesting, *
> *can u sent me attachement
> *
>
> On 10/29/09, grl
hi anish actually i dont want it to sort i want the name of the top 10
learner in top 10 learner column according to there rank (Rank 1 to Rank 10)
can it be possible
On Fri, Oct 30, 2009 at 1:47 PM, Anish Shrivastava wrote:
> Hi Prashant,
>
> Why dont you use SORT the column which you want..It
*Hi friends it is interesting, *
*can u sent me attachement
*
On 10/29/09, grlinks-karthik wrote:
>
> I need to calculate in interest excel sheet could any one help me with?
>
>
>
> Its like insurance calculation method, user will pay premium yearly
> basis, Period 20 years
>
> Conditions
>
> 1.
Hi Prashant,
Why dont you use SORT the column which you want..It's juz very simple.
Try it once :)
Cheers!!
ANISH
On Thu, Oct 29, 2009 at 7:16 PM, Prashant Bhawar
wrote:
> i want top 10 performing learner from all the data( i want there names in
> that column by Rank 1 to Rank 10 ).
>
> --
>
*Hi *
**
*Prashant, Sudhir here*
**
*i edit in your excel file, by conditonal formatting in overall percentage
column*
*and highlight top 10 performers.*
**
*i think u will use my tips and statisfied with it.*
**
*if any other method you will do, then please sent me.*
**
*thanking u
*
On 10/29/09,
17 matches
Mail list logo
