Posts by Taz

Derk

Could you give an example of this please....

btw thanks all for your help so far

Hiya

Can any tell me how i would put a formula together that will allow me to produce a set figure if a certain criteria is met?

As an example i have to allow the spreadsheet to put a set figure in a box if a number is over these criteria:

<140 then -20 points, between 140 and 190 give them 10 points and over 190 give them 20 points.

Any ideas?

hi

anyone know how to make the font bigger in the "pick from list" facility in excel?

not 100% sure whats gone wrong with this but i get an error on this line?

Label1.Caption = Range("A1").Offset(ComboBox1.ListIndex, 1)

any ideas? and what happens if once it has selected an item if i want the details of that row put into a text box in the form.... is that possible?

Hard to say over here without having an attachment to show what i mean... my form contains various sections one being a drop down list which reads the contents of itself from the spreadsheet. what i need is for the item to be selected from the drop down list and for the system to find that entry and then jump across a few columns to one called location and show me in a report box exaxtly where the item is...

any wiser?
:barf:

Hiya

Can someone take a look at the attachment and maybe point me in the right direction. the form that is based within it should allow me to select a bin from a list and then what i want it to do is either show me the location or the availability of it.

can someone take a look and let me know please

Thanks

ummmm where is the attach option gone?

Hiya peeps

Does anyone know if its possible to create a table on contents in Excel that will relate to the individual worksheets in the workbook?

after lots of checks i have found that it only works on a spreadsheet that starts on A1, if there are gaps or the data starts on A7 for example it comes up with the #REF

Does that mean anything?

Taz

is there anything that could make every blank cell in the spreadsheet come up with #REF?? have check the test one and its perfect, just what i want but why wont it work on the live one

Hiya Derk.... have been watching your replies with interest for a while, you certainly know your stuff!!!

have tired this and all it does is fill in ALL the blanks with #REF any other suggestions please?

I wish Andy..... the sheets contain thousands of entries which are automatically produced for me, i would be there for weeks inputing that as they change from report to report....

this is why i am looking at a new solution

its me yet again, sorry about this, just seem to have a lot of excel work and no time to really get into the nitty gritty of it all..... hence the need of help...

have a spreadsheet demo attached, which has various bits of information and what you will see is there are areas missing, these need to be copied from the cells above.... anyone got any ideas?

hi Andy... have attached a picture of the sort of dialogue box i want and it would contain items from either a predefined list or a list of information stored in cell contents, the same would be for the picutres and the tables one is basically a dialogue box that will allow me to select a preconfigured table and put it into the document.... make any more sense

Thanks Andy for your reply..... part of it will be a dialog box that will pop up in the centre of the screen allowing users to select a phrase or paragragh of txt, one will allow them to select a picture, one will allow a selection of various tables....

any help?

Howde friends

does anyone know the best way to create a vba script that will allow me to click an icon on the toolbar which would then produce a little box and allow me to select say a picture from a selection and then place it in the worksheet or document? am trying to automate a set of sequences...

any ideas?

this might help you:

Sub Dup_cells()
'
' Dup_cells Macro

On Error GoTo EndMacro
If Selection.Columns.Count &gt; 1 Then
MsgBox "Sorry, You May Only Select Cells In One Column.", vbExclamation
Exit Sub
Else
End If
If Selection.Rows.Count &gt; 1 Then
Set rng = Selection
Else
MsgBox "Please Select Cells In Multiple Rows.", vbExclamation
Exit Sub
End If
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
i = Selection.Cells.Count
n = 0
For r = rng.Rows.Count To 1 Step -1
v = rng.Cells(r, 1).Value
If Application.WorksheetFunction.CountIf(rng.Columns(1), v) &gt; 1 Then
rng.Rows(r).EntireRow.Delete Shift:=xlUp
n = n + 1
End If
Percentage = n / i * 100
Application.StatusBar = "Please Wait Now Processing: " & Percentage & "%"
Next r
EndMacro:
MsgBox Format(n) & "Duplicates Will Now Be Cleared.", vbInformation

End Sub

Conditional formating is quiet easy to use for items like this. If you can share a little more detail i am sure we can help.

but in a nutshell, go to Format, Conditional formating, set the options for condition 1, (cell is equal to 1.50*) then set the cell options by clicking on the Format button and selecting the options you want shown if that number appears.

You can set more options if required

Thanks for all your help on this one guys, it worked well.....

thats great!!!! but how do i get it to except all critieria, there are 7 sets of values to match....

Hi looking for an answer to this problem... need the best solution to allow me to identify how many enteries of a certain number exist in a sheet, just like a count formulae except there are a number of variables... any ideas?