Hello !I am trying to make a drop down list box in excel sheet(just like"Validation&#92; List"does in Data menu)
599598
Yes, this is possible.  Using the control toolbox toolbar, insert a drop-down combobox.\n\nRight click on the combobox and select Properties.  In the properties box change ColumnCount to "3", and set the field ListFillRange to the 3 column range you want to use.\n\nHowever the return value (LinkedCell) will only be equal to the selected field in the 1st column, unless you change the BoundColumn field to a value like 2 or 3.
367046
your question is not quite clear, may be you can explain it to me and i hope i could be a help to you, I been working with Data Reports in VB6 lately, and it works fine with me.
901683
Since you don't want to create a blank record in the pick list table, the easiest thing would be to, after you create bind your data from the database to the dropdownlist, programmatically insert a blank in the first position of the dropdownlist like so:\n\ndropdownlist.Items.Insert(0, "                   ")\n\nJust remember this has to happen after the data is bound, otherwise the binding will remove the item that you inserted at the first index of the dropdownlist.
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
1132627
start the list with <ul>\nput a <li> before each bulleted item\nyou can put a </li> at the end of the bullet but its not necessary\nend your list with a </li>\n\nTADA!\n\nGood ol' HTML!
945969
You can not do this in the easy way, you have to use macros (VBA) to access the properties of that scrollbar in code\nSheet1.Shapes("Scroll Bar 1")..Min = 1\nSheet1.Shapes("Scroll Bar 1")..Max = 1\nWhere Sheet1 is the name of your sheet (Not Tab Caption)\n\nMail me for more info\n\nEnjoy my profile, I am the VBAXLMan
995507
A cell can either contain data or a formula, not both.\n\nYou will need to create a macro and assign it to the onChange event for that cell.
230306
What hurricane is describing is using a string qualifier.\n\nFor example (in this example, replace the . with a tab):\n\n'Text column 1'. '04323221'. 'Hello'\n'Blah blah blah'. '34332321'. 'Paris'\n'Random ol&#92;' text'. '9223221'. 'Green'\n\nNotice that each field begins and ends with a single-quote. The idea is that by qualifying each field with single-quotes, Excel will import the contents as a string.\n\nThat sounds great on paper and should work in theory, but it won't, because anytime Excel sees all digits, it wants a number, even if you use qualifiers.\n\nYou have to manually set up the import in Excel to work properly, if you want those zeros saved.\n\nTo do that:\n\n1. Open Excel\n2. Use File --> Open to open your TSV file\n3. Set the Files of type drop-down to be All Files, navigate to where your TSV is saved, and open it.\n4. In the dialog box, choose Delimeted, skip any rows that need skipping, choose the right encoding and click Next\n5. Make sure Tab is chosen in the delimeters and, if you have opted to use a text qualifier, it is selected.\n6. Click Next\n7. For columns that will contain leading zeros, click on that column, then choose text for the Column data format from the radio buttons at top right.\n8. Click Finish.
311771
Right click in any menu toolbar, it will show you the common toolbars... select the bottom option "Customize"... In the toolbars TAB look for and select "Worksheet Menu Bar" this is the one that contein file, edit, view, insert, format ....etc\n\nYou're done!\n\nPlease vote!
614180
In VBA (as used in PowerPoint) declaring a variable and assigning a value must be separated.\n\nDim astring as String\nastring = "Test"\n\nIn VB 2005, VB.NET, etc. - your expression would be fine.\n\n*** Additional Stuff ***\nSounds like you're really struggling ... In the code module for the presentation you'll need to put the code in a procedure ... here's an example\n\nSub TestThis()\n    Dim astring As String\n    astring = "Test"\n    MsgBox (astring)\nEnd Sub\n\nAfter this, you'll be able to run this code as a macro ... Tools >> Macro >>> Macros ... then select the "TestThis" macro and run it ... you'll get your message box.\n\nGood luck!
693009
This code is from 4guysfromrolla.com.  There are other ways to accomplish this as well.  Hope this helps!\n\n\n<script language="vb" runat="server">\n  ...\n   \n  Sub dgPopularFAQs_ItemDataBound(sender as Object, e as DataGridItemEventArgs)\n    ' First, make sure we're NOT dealing with a Header or Footer row\n    If e.Item.ItemType <> ListItemType.Header AND _\n         e.Item.ItemType <> ListItemType.Footer then\n      'Now, reference the LinkButton control that the Delete ButtonColumn \n      'has been rendered to\n      Dim deleteButton as LinkButton = e.Item.Cells(0).Controls(0)\n\n      'We can now add the onclick event handler\n      deleteButton.Attributes("onclick") = "javascript:return " & _\n                 "confirm('Are you sure you want to delete FAQ #" & _\n                 DataBinder.Eval(e.Item.DataItem, "FAQID") & "?')"    \n    End If\n  End Sub\n</script>\n\n<form runat="server">\n  <asp:datagrid id="dgPopularFAQs" runat="server"\n      ...\n      OnItemDataBound="dgPopularFAQs_ItemDataBound">\n\n      ...\n  </asp:datagrid>\n</form>
990843
You can call it from VB6 using\nWorksheetfunction object\nthis object has all the functions in Excel\n\nenjoy\n\nXLMan
1065789
Make sure source works. and destination s.has cells selected as numbers. I assume you know how to do it. But here it is in case:\nSelect column. Right click it and go to format cells.Stay in number tab and select number. \nIt should work fine.
958780
use the disabled property of the combo box (select list as it is called in HTML).\nwhen the disabled property is true combo box will be disabled and when it is false it will be enabled
393718
It sounds like you are using Excel as a form template of sorts.  I gather that your goal here is to prevent people from entering endless text answers, and instead keep their replies brief.\n\nWhat you may need to do is limit the text answers to a certain number of characters, rather than words.  If you select the cell that will hold the text answer, and go on the menu to Data > Validation, then under the Settings tab, select text length.\n\nSet this to some value like 1000 characters, and you will get the result you seek.  Also you can adjust the error message that the user will see in here.\n\nIn old versions of Excel there was a frequent limit of 255 characters in a cell.  As long as you have a recent version (such as Excel 2003) you will be able to store and save worksheets with more than 255 characters.  However if you attempt to copy the entire worksheet you will receive a truncation warning.  To get around this, just copy and paste the individual cells, and the Excel will let you get away with it.
820137
You nailed it. They're called drop down boxes: Heres a sample code:\n\n<form id="color" name="color" method="post" action="yourform.php">\n<label>Color\n<select name="select">\n<option>Red</option>\n<option>Blue</option>\n<option>Green</option>\n<option>White</option>\n<option>Black</option>\n<option>Orange</option>\n</select>\n</label>\n</form>
142548
2 different types:\n\n<INPUT TYPE=text VALUE="" NAME="textbox" SIZE=15>\nand\n<TEXTAREA NAME="myTestArea"></TEXTAREA>