Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kragster
  • Content: Threads
  • Order by date
  1. kragster

    Problem with data validation

    Hi, About a week ago, something weird happend to one of the spreadsheets that I am continously working on. All the drop down boxes disappeared and now I cant seem to get them back. What I do when I want to make a drop down menu is this: I mark the cell where I want it to make a drop down menu...
  2. kragster

    Simple macro problem

    Hi, I am trying to make a simple macro, but I'm stuck and need some advice. The macro should go though the cells of a row and when the cell contains specific data it should delete the entire column. This is my code so far (probably not the right way of doing it): Sub delColumn()...
  3. kragster

    Help with loop..

    Hi, I have a bit of trouble understanding a part of this loop, so if anyone would be so kind to translate it, it would be much appreciated. Dim AssayRowIns AssayRowIns = 4 Do Until Range("A" & AssayRowIns) = "" Rows("" & AssayRowIns & ":" & AssayRowIns + 6 & "").Insert...
  4. kragster

    macro that sorts a range from the last 5 characters

    Hi, I have a problem sorting a table from a column containing order numbers. The order numbers have the following format: ABC00001 -> three letters succeded by 5 numbers. What I wanna do is sort the orders by the last 5 numbers, disregarding the three letters. Can anyone help me on the way here?
  5. kragster

    practice for protecting formulas

    Hi, I have a rather large spreadsheat containing a table of data. Some of the cells contain data from user input, and some contain VLOOKUP formulas. What is the best practice for protecting these formulas? I tried making the cells with formulas writeprotected and then protecting the whole...
  6. kragster

    Displying xls file in a HTML document?

    Hi, I would like to display an excel file from my LAN on a webpage and until now I have used this code: <IFRAME src="Path to excelfile" frameBorder=0 width=750 height=750> </IFRAME> I would like to know what other solutions are available to display a dynamic excelfile on a webpage. When it is...
  7. kragster

    Can an image be related to a specific cell?

    Hi, I am just finishing the work on a new ordersystem. The basics of the system is a row in the top of the sheet where users can input data. Then they press a submit button and the row is inserted into a table below. What I am thinking about making as a final touch, is a small button next to...
  8. kragster

    Counting cells with data in them

    Hi, I am still working on this ordersystem and have a couple of questions in this regard. 1. First of all my Excell seems to have shifted language all of a sudden. All the excel commands are now in danish which is very annoying, when you have gotten familiar with the english names. Is there...
  9. kragster

    sdadsads

    Hi, I have stumbled over a problem during the development of an order system and would like some advice. It's a simple system where the rows are orders and columns are different data for the orders. Some of the cells contain drop down menus and some of the cells contain formulas (VLOOKUP...
  10. kragster

    Sorting but leaving the empty cells on top

    Hi, I have created a macro for sorting a table by a column: --------------------- Sub SortByModtaget() Range("B10:O65536").Select Selection.Sort Key1:=Range("L10"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _...
  11. kragster

    sorting a column with dates

    Hi, I am making a macro in excel to sort a column by dates. The dates have the following format dd/mm/yy. This is the code I use: Sub SortByBestilt() Range("B10:O65536").Select 'Header to sort after Selection.Sort Key1:=Range("H10"), Order1:=xlAscending, Header:=xlNo, _...
  12. kragster

    shifting the contents of a table 1 row down..

    Hi. Can someone help me create a macro for a button, that shifts all content in a range (table) one row down? Thanks in advance.
  13. kragster

    Dynamic Cell Background Color

    Hi. Is there any way to control the background color in a column, so that when the cell is empty the background color is set to red, and yellow if the cell is populated?
  14. kragster

    largest number in a column

    Hi, Could anybody help me out, or point me in the right direction. I need a macro for a button, that checks a column for the highest number and then inserts the next consequtive number into the selected cell.
  15. kragster

    Userform maximum entries?

    Hi, I have made a userform for a spreadsheet activated by a button. For some reason the userform will only show 12 entries, even though the source has a lot more. Can this be defined anywhere? I cant seem to find it.
  16. kragster

    selecting next cell in column

    Hi, I am new to VBA, but have programmed a bit before. I am making an application in excell using macros. Is there a simple VBA command to select the next cell in a column?

Part and Inventory Search

Back
Top