Posts by aadarsh

Re: For-Next-Loop

Hi

If i remember this right, they work if you pu the alphabets in single quotes

Aadarsh

Re: passing ranges as arguments

hi

at which libne do u get error...try running the code line by line and tell me

Aadarsh

Re: passing ranges as arguments

Hi

You cannot pass b3 and s3 and expect the to be assigned as ranges..

You can to one of the following.

1. In your main program define a range for "b3" and one for "s3" ad then pass the ranges
2. The other option is to pass them as strings - sorter("b3","s3")
Aadarsh

Re: read only when file opened twice

Hi

Another soln would be to share the workbook, so multiple ppl can access at same time

Aadarsh

Re: Disable Clear (format, all, etc.) and prevent deleting, copying, and moving sheet

Hi

As for moving of the sheet or renaming..protect the workbook with the structure being protected(it also prevents clear as far as i know)

Aadarsh

Re: Disable Clear (format, all, etc.) and prevent deleting, copying, and moving sheets

Hi

Why dont you protect worksheet for the first one, and protect workbook for the other...
Should be pretty easy to use and figure out

Aadarsh

Re: read only when file opened twice

Hi

VBA(or excel) as such cannot prevent copies being made, you can ask your network administrators though, they will be able to restrict permissions and prevent copying of the file

Aadarsh

Re: 4 condition sort, subtotal, fill down adjacent cells

Hi

Could you attach a sample document so i can understand better

Aadarsh

Re: function for list

hi

how do u know which particular lines data is to be extracted, is there any way of determining this

Aadarsh

Re: disable leftclick with exceptions

Hi

Why dont you just use worksheet protection, and lock all cells or objects except the ones you want them to select

aadarsh

Re: UserForm Excution truble

Can you attach a copy of your workbook

Aadarsh

Hi

I have a word template into which i need to feed data, which is filled by users into an excel userform...i know the obvious quest why excel..well the data is used for doing other stuff also..

But this is where i am getting stuck, i need to insert selected data from the userform to the header of the attached word template file.
All the places marked in red is where text from the userform goes

I need to know if there is a way to write an excel VBA code to do this

Aadarsh

Re: Getting a application-defined error???

Hi

On which line does the error appear

Aadarsh

Re: Integration in VBA

Hi

If you need to integrate in excel or in any other computer program for that matter, u have to use formulae to approximate the integration like the trapezium rule

Aadarsh

Re: Line Numbers in VBA

Hi

Thanx ..will look for the addin

Aadarsh

Re: Line Numbers in VBA

Hi

So there is no direct way, except to copy and paste code in word, the problem with this is that the colour coding say for comments dissapears, i have to manually add the colouring later.

I need a way to work around this, an addin perhaps(if one exists)

Hi

Simple VBA Question(nothing to do with excel)

Is there any way for VBA to print out line numbers when printing code
I basically have to export entire code to print with line numbers so easier to reference for changes and for documentation

Aadarsh

Re: Listbox manipulation

Hi

Use the Listbox1_Change property
The value for the food is stored as Listbox1.Value
You can extract this and then continue with your process

Aadarsh

Re: Angles with VBA and macro

Hi

Your question seems very confused, could you explain what you are exactly trying to do

Aadarsh

Re: Using Top Property to position a checkbox

Instead of the last 2 lines, try using

selection.top=itop