Posts by jonny

Re: Phone validator for textbox

Batman, thank you for an information. I have confused by VB.NET & MS Access.

Ian, thanks a lot for your effort to help.

Hello, friends.

How to build "pnone number" validator for textbox?

For examle: I need format +xxx-(x)-xxxxxxx.

Thanks

Re: Edit Box control locked?

If I use toolbox, I need to build an userform. ANd I want to build it in Excel worksheet.

How to unlock Edit Box control in the toolbar?

Thanks

Re: Drop Down Control

Dear WillR.

So simple & wonderful!

Thanks a lot.

I have a drop down control with a certain range.
I want to show value of the cell with offset (0,1) according to selected value in a drop down control.

For a better explanation I have attached the *xls file (see output cell)
for example: for "jan" I will get $8.42, and for jul I will get $81.55.

Thanks in advance.

Re: "Range" protection

Thank you, friends.

Re: "Range" protection

Thank you.

As I understand in earlier versions it doesn't work?

Hello, friends.
Is any way to protect some selectionin a sheet.
For example I would like to protect columns A:B, and to allow users to use other columns.

Thanks in advance.

Re: Activation of UserForm?

Batman, thank you for a help.

Where should I put this macro? In "module"?

Thanks

How ot activate the UserForm from Excel: Macros-->Custom Button.

How to empty array in VBA?

May I put personal.xls on d:\? If it possible how I define the new path it in VBA?

Re: If the cell contains lowercase letter?

This solution is really simple
Thank you.

May somebody advise easy code or function that returns "True", if the cell contains at least one lowercase letter.

Thanks.

Re: Combine several *.xls files into one

Dear, Turbo.

Thank you a lot for your solution. It exactly what I need.
I trully appreciate your assistance.

Thanks again.

Re: Combine several *.xls files into one

I want them in a same sheet.
All files in a same folder.
They're not named in set format, but columns ito the files have the same format and names.

First I need to copy one file, after that from the last row + 1 the next file and e.t.c

Re: Functions do not work the cell contains "~" sign??

Hi, Guys.

Thank you for you posts, I have found in Microsoft site some nice solution: http://support.microsoft.com/d…aspx?scid=kb;en-us;214138

Needs to replace "~" by "~~" , by "Replace" dialog box, and then to put the function.

Best regards..

Functions do not work the cell contains "~" sign. Is any "magic" meaning to this sign??

1. Can not find the cell with "vlookup"
2. Can not filter cells contain this sign.

Please advise.

I have excel files (~50 files) with a same format. Is any way to combine them into one excel file?

Thanks in advance.