http://www.contextures.com/xlUserForm01.html
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. B
Dear All,
Please advise me how to implement user form in excel via VBA.
Please assist me with sample & fundamentals of the code.
Regards,
Abdul Hakim Khan
--~--~-~--~~~---~--~~
Hi All,
First of all i would do the thanks to all the member those are associated
with this group.
My query is that can we use vlookup, hlookup and lookup function with array
function of EXCEL. if any one now this please send me the excel file with
and example.
i want to learn array function in
Dave is correct,
The wording No Sales in month .. (thus I chose no sales) is part
of the body of the sheet. I can't rely on the person to put the data
in the same spot so I want to search each sheet for that type of
wording somewhere on the sheet itself. Also the values for each sheet
tab /
Hi Robin,
I have tried to understand your needs, but cannot.
1. "a macro which will read my file name"
This we can do.
2. "i want that my macto add a
column D and reads my saved file name and put a digit 25 in that D
coulmn in range d1 to d last (till column A, B, C, carries data) ??"
This I
Hi Harmeet,
This is what i am exactly looking for.
Thanks a lot. Keep rocking.
Regards,
Sharma
On Fri, May 29, 2009 at 8:53 PM, Harmeet Singh wrote:
>
>
> On Fri, May 29, 2009 at 1:23 PM, amrahs k wrote:
>
>> Hi Harmeet,
>>
>> I just want a macro for validating a particular column in
Hi Dev
Thank you very much.
Regards
Ramesh
On Fri, May 29, 2009 at 11:35 AM, Dev wrote:
>
>
> Ramesh - There are multiple ways to accomplish this. But since your
> request is to just sum the numbers for the given column, here is the
> snippet which is not production ready.
>
> Dim oRange as R
Hi Bala,
Thanks for your help and efforts provided for the below task.
Regards,
Sharma
On Fri, May 29, 2009 at 3:26 PM, bala wrote:
>
> Hi
>find the code below
>
> Sub test()
> Dim strAddress As String
> strAddress = Range("B65536").End(xlUp).Address
> Range("B3").Select
> While ActiveCell
hi friends, i am looking for a macro which will read my file name
(saved file where i will run macro) and print a code in given range of
a column, for an example if my file name is test (saved in desktop) is
carring some data in column A, B, and C, i want that my macto add a
column D and reads my
Try rhis formula to get the 16 digit number.
CELL B2 :- =TEXT(A2,REPT("0",16))
Then these to get the 4-digit and 12 digit parts.
=LEFT(B2, 4)
=RIGHT(B2, 12)
--~--~-~--~~~---~--~~
--
Hi TAlgo,
Have a look at the attached. I've included 2 different macros because I wasn't
sure of what you really need.
Hope this points you in the right direction.
Regards - Dave
> Guys,
> trying to create a macro which will copy column A to column B. This is
> simple but only exception I m loo
Hi George,
Can't quite understand your request.
"column F down untill we reach two empty cells in columns F and J"
But your sample data doesn't have 2 empty cells in both F and J.
Perhaps you could attach a sample workbook with a bit more data - say 20 rows.
Regards - Dave.
> Date: Fri, 29 May 20
12 matches
Mail list logo
