# Posts by chrisxs5

Re: Assign autoformat to a macro

Then Format
Then AutoFormat
Then Classic2
Then Click OK

I think this is what you are looking for.

Re: Start Macro X minutes after opening worksheet

This would help me with one of my problems but I was just wondering if there would be a way for the macro to start after the datafeed finished versus the time setting. If the data builds beyond a 2 minute time level or drops in time, the macro could start early or waste time.

Re: Looking up and using formulas from another WS

I am not the best at VBA so hopefully someone else will step up and help.
I will take a look at on Monday morning, sorry I dont have the time over the weekend. If not worked out by Monday I will get right on it. Good Luck

Re: Looking up and using formulas from another WS

So I am playing around with the choose formula
which allows up to 29 values. So here is what I came up with

=CHOOSE(D11,IF(D11<=2,\$A11*\$B11),IF(D11<=3,\$A11*\$B11),IF(D11<=4,\$A11*\$B11),IF(D11<=5,\$A11*\$B11),IF(D11<=6,\$A11*\$B11),IF(D11<=7,\$A11*\$B11),IF(D11<=8,\$A11*\$B11),IF(D11<=9,\$A11*\$B11),IF(D11<=10,\$A11*\$B11),IF(D11<=11,\$A11*\$B11),IF(D11<=12,\$A11*\$B11))

This appears to work and using the formula palette is very manageable, So if someone Knows why this wont work (it sounds to easy to me) please let me know.

Re: Looking up and using formulas from another WS

Well you are restricted to 7 so the best way beyond that would be to use vba.
How many are you going to need?
Will this be something you do once, or constanly changes?

Re: newbie vba help

Alt+F11 or right-click on the tab.
You will now be in VB On the left you will see your pages and maybe modules.
click through those to see the code.

Re: Desperate!-covert data in columns to rows and columns with intersection values

Not a God I just figured them out a couble of months ago and now they're my answer to evrything. So have fun! :guitar:

Re: Looking up and using formulas from another WS

Here is the other one you need
=IF(D11<=2,\$A11*\$B11,IF(D11=3,PI()*\$C12^2,IF(D11=4,1/3*PI()*\$C13^2*\$B13)))
Notice this doent actually import a formula but rather has all the formulas. Drag fill the formula down as needed.

Re: Looking up and using formulas from another WS

I think this what you are looking for the shape
=CHOOSE(D11,'Table 1'!E10,'Table 1'!E11,'Table 1'!E12,'Table 1'!E13)

Re: Textbox to multiple sheets

Thanks willr your code did do it, the problem was in a offset formula in my named range, I got that worked out and the code did the trick, thanks.

Re: Formula Evaluate to Blank if Referenced Cell Blank

No problem, so many people help me out its nice to help somebody else.

Re: Textbox to multiple sheets

Sorry for not better describing but that one box will go to just those two pages. I tried that line of code and it didnt work, I didnt really see anything that named the specific sheet so I edited it to

Code
``````Range("DateFirstName").Cells(txtRow.Value) = txtFirstName.Value

and

Sheets("Date Info").Range("DateFirstName").Cells(txtRow.Value) = txtFirstName.Value``````

Neither worked.

Re: Clear Button error

I dont know if that helped out Joe but I appreciate you taking the time to write that out. It helped me understand some much needed information. Thanks iwrk4dedpr :rock:

Re: Textbox to multiple sheets

I want the value placed within range "DateFirstName" on sheet "Date Info".
The txtrow box contains the row value.
The box is located on a user form in sheet "Data" and the values for that page are placed with

Code
``Range("FirstName")(txtRow.Text).Value = txtFirstName.Value``

Re: Output a range selected by the user

Our apoligies, we realize that you have been looking for two days and are now frustated with us when you did not get your answer within minutes. We realize that since we all volunteer our time to help each other that we should feel guilty. I hope your friend can help when you need two lines of code.

Re: Hiding formulas

Also notice on your formula bar the "="
Click on that and you can select the formula you want to use.
Read through the descriptions and play around with the formulas it will open a whole new world.

Re: Hiding formulas

Put a value in cell a1 like 5
Put this =IF(A1>10,A1,"") in b1
Its broke apart by the commas first is your equation A1 value is greater than 10 then Your answer if True A1 Value Then False ""
Hope that explains it

Re: Hiding formulas

You could use an if formula and make [if answer is zero or less than value egauals "".]
Or select tools>options>and uncheck zero values. But that does the whole page.

I have a userform textbox that I would like to send the value to multible sheets.
The value to sheet1 is

Code
``````Private Sub txtfirstName_AfterUpdate()
Range("FirstName")(txtRow.Text).Value = txtFirstName.Value
End Sub``````

I tried this

Code
``````Sheets("Date Info").Select
Range("DateFirstName")(txtRow.Text).Text = txtFirstName.Value``````

but as always no luck.